Once you have decided on the default and temporary tablespaces, the password, and the quotas, you are ready to create the new user.
CREATE USER command is used for this.
CREATE USER command in the following MouseOver illustrates commonly used syntax elements.
lways assign users a default tablespace, even if you do not plan to allow them to create objects. That way you do not have to remember to change their default tablespace settings later if you do allow them to create objects.
When it comes to quotas, you can place as many
clauses in the
command as you need.
Users who do not need to be restricted in terms of space can be assigned an unlimited quota. Alternatively, you can assign them no quota at all, and give them
If you do not want to type in commands, you can use Security Manager to create a user. Security Manager, as you will recall, is one of Enterprise Manager's management pack applications. This Simulation walks you through the process of creating the
user, shown earlier, with the help of the Security Manager.
Create User With Security Manager.