RelationalDBDesign RelationalDBDesign


Creating Users   «Prev  Next»
Lesson 3 Before Creating a User
ObjectiveDecide on attributes for a new user.

Before Creating a User

Before you create a user, you must consider the following:
  1. The tablespace you want to use as the default for objects created by the user.
  2. The temporary tablespace used when the user executes queries that require sorting large amounts of data.
  3. The user's initial password and whether or not you want that password to be pre-expired. Pre-expiring a password forces a user to change it to some value other than the one you chose initially.
  4. The profile assignment, if any, that you want to make. Profiles specify how often a user must change his or her password, and also can be used to limit the amount of database resources available to the user.
  5. The amount of disk space available to each user. This is referred to as the user's quota.

Example: Creating a User Account

Suppose you want to create a user account for a database application developer named Nick. Because Nick is a developer, you want to grant him the database privileges and roles that he requires to build and test his applications. You also want to give Nick a 11 MB quota on his default tablespace so that he can create schema objects in that tablespace.
To create the user Nick:
  1. Go to the Users page
  2. On the Users page, click Create.
The Create User page appears, displaying the General subpage.

Before Creating User

  1. In the Name field, enter NICK.
  2. In the Profile list, accept the value DEFAULT. This setting assigns the default password policy to user Nick.
  3. Accept the default value Password in the Authentication list.
  4. In the Enter Password and Confirm Password fields, enter a password that is secure. Create a password that is secure.
  5. Do not select Expire password now. If the account status is set to expired, then the user or the database administrator must change the password before the user can log in to the database.
  6. (Optional) Next to the Default Tablespace field, click the flashlight icon, select the USERS tablespace, and then click Select. All schema objects that Nick creates will then be created in the USERS tablespace unless he specifies otherwise. If you leave the Default Tablespace field blank, then Nick is assigned the default tablespace for the database, which is USERS in a newly installed database.
  7. (Optional) Next to the Temporary Tablespace field, click the flashlight icon, select the TEMP tablespace, and then click Select. If you leave the Temporary Tablespace field blank, then Nick is assigned the default temporary tablespace for the database, which is TEMP in a newly installed database.
  8. For the Status option, accept the default selection of Unlocked. You can later lock the user account to prevent users from logging in with it. To temporarily deny access to a user account, locking the user account is preferable to deleting it, because deleting it also deletes all schema objects owned by the user.
  9. Grant roles, system privileges, and object privileges to the user
  10. Assign a 10 MB quota on the USERS tablespace
  11. If you did not click OK while assigning the tablespace quota (previous step), then click OK now to create the user.

Preparation For Creating User - Quiz

Click the Quiz link below to answer a few questions about preparing to create a user.
Preparation For Creating User - Quiz