Step 7 - Administering Users
Learn Oracle - Creating Users
In this section, Oracle DBA create a user named MYUSER, set the password, and assign MYUSER
to the USERS tablespace. This enables MYUSER to log in to the database
Later, you will learn how to edit and assign roles to this user.
To create a database user, do the following as user SYS or SYSTEM:
1. Click Create on the right hand side of the Users page.
The General page is one of a series of pages in the Users property page.
2. Enter a user Name. For example: MYUSER
3. Leave Profile set to DEFAULT. The profile specifies the resource limit
Note that this profile does not allow the user to log in to Enterprise Manager. To
do so, the user needs to be assigned the DBA role.
4. Leave Authentication set to password.
5. Enter the password of your choice in the Enter Password and Confirm Password
6. Do not check Expire Password now. If the account status to set to expired, then the
user or the database administrator must then change the password before the user
can log in to the database.
7. For the Default Tablespace field, click the browse button (flashlight) and select the
USERS tablespace. While users can specify different defaults for each user, it is
easiest to define a default permanent tablespace and a default temporary
tablespace at the database level, instead of the user level.
8. For the Temporary Tablespace field, click the browse button (flashlight) and select
the TEMP tablespace. For more information on the TEMP tablespace,
9. For Status, select Unlocked. For suspicious users who Oracle DBA do not necessarily want
to delete, Oracle DBA can lock them out using this.
10. Click OK. The Users page is displayed, and Oracle DBA can now see an entry for the new
The Users General page has links to several other property pages. For example, Oracle DBA
can specify user roles, privileges, quotas, consumer groups, and proxy users.
Consumer groups are groups of users, or sessions, that are grouped together based on
their processing needs.
Using a Shortcut to Create Users
If Oracle DBA later want to create other users similar to user MYUSER, or another user, Oracle
provides a shortcut for doing so. On the Users page, Oracle DBA can create a user with the
same attributes as another user as follows:
1. Select the user that Oracle DBA want to duplicate.
2. From the Actions menu, select Create Like.
3. Click Go. The Create User General page appears for a new user with the same
attributes as the duplicated user.
The Actions box also provides shortcuts for other actions, as well as providing a
means to display the SQL DDL used to create a user.