RelationalDBDesign RelationalDBDesign


Managing Users Connectivity   «Prev  Next»
Lesson 7Creating a User
ObjectiveCreate a Database User

Creating a User in Oracle

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.

  1. You are creating a new user named coin_admin.
  2. The initial password for this user will be the same as the username.
  3. The default tablespace for this user will be the user's tablespace.
  4. The user's temporary tablespace will be temp.
  5. The user will be given the default profile. You will learn more about profiles later in this course.
  6. The user will be allow to use 5000 kilobytes of disk space in the user's tablespace.
  7. The user will be allowed to use 10 megabytes of disk space in the tools tablespace.
  8. The keyword UNLIMITED allows the user to use any amount of disk in the temp tablespace.

Create User

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.

Unlimited -Tablespace
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.

Creating Users - Quiz

Click the Quiz link below to answer a few questions about creating users.
Creating Users - Quiz