Once you have decided on the default and temporary tablespaces, the password, and the quotas, you are ready to create the new user.
The CREATE USER
command is used for this.
The 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
QUOTA
clauses in the
CREATE USER
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
UNLIMITED TABLESPACE
privileges instead.
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
COIN_ADMIN
user, shown earlier, with the help of the Security Manager.
Create User With Security Manager.