When creating a new user, the spreadsheet consists of two columns indicating the
name of the object privilege and whether or not the Grant Option is specified for
that privilege.
When enabled, the Grant Option allows the user to grant the specific object
privilege to other users and roles. By default, this option is disabled. To enable the
grant option, click on the specific spreadsheet entry. The "X" is replaced with a
check.
When creating a role, the spreadsheet consists of a single Object Privilege column.
Create User Property Sheet: Quotas Page
On the Quotas page of the Create User property sheet, you can specify the
tablespaces in which the user can allocate space and the maximum amount of space
the user can allocate within each tablespace. This page is available in Advanced
mode. The Quotas page contains the following items:
Quota Details
Scrolling list of the tablespaces in the database and the maximum amount of space
the user has been allowed in each tablespace. The list can be sorted on the
Tablespace or Quota Size column.
To specify a quota size for a tablespace, select the tablespace in the scrolling list and
specify a quota size by clicking on the None, Unlimited, or Value button.
None
Click None if you do not want the user to have any quota on the selected
tablespace.
9-10Oracle Enterprise Manager Administrator’s Guide
Users Folder
Unlimited
To specify an unlimited quota for the tablespace, click the Unlimited button. With
an unlimited quota, the user can allocate an unbounded amount of space in the
tablespace.
Value
To specify a specific quota, click Value and enter a quota value in the adjacent text
entry field. Select the K or M button to specify Kilobytes or Megabytes.
Note:
If the user has been granted the UNLIMITED TABLESPACE System
Privilege, the Quota Details option is disabled.
Create Like User
To create a new user with the same attributes an existing user:
1.
Choose Create Like from the User menu. The Create User property sheet
appears with all parameters specified except the Name.
2.
Modify any property sheet parameter for the new user as necessary.
3.
Click Create.
You can also perform this operation by selecting a user from the navigator and then
choosing the Create Like menu option. You must enter the name of the new user
and enter a new password if the Password button is selected.
The format and content of the Create Like property sheet is identical to the Create
User property sheet. Refer to Creating a User on page 9-6 for information about the property sheet.
Altering a User
To change the characteristics of a user:
1.
Select the user from the navigator to display the user details property sheet.
2.
Modify the property sheet parameters as necessary.
3.
Click Apply.
You can also display the Quick Edit property sheet by selecting a user from the
multi-column list and choosing Quick Edit from the context sensitive menu. The
Quick Edit property sheet is identical to the details property sheet.
Managing Database Security
9-11
Users Folder
The details/Quick Edit property sheet is identical in format and content to the
Create User property sheet except that the name field is read-only. See Creating a
User on page 9-6 for information about the property sheet.
Suggestion: If you want to add privileges or roles to multiple users, use the Add
Privileges and Roles to Users menu item. See Adding Privileges or Roles to Users on
page 9-12.
Attention: If you alter an object, such as a user named DAVE or a role named
CLERK, in any location of the navigator, all instances of the object in the tree are
changed.
Removing a User
If you no longer need a particular user in your database, you can remove the user
by selecting the user to be dropped from the Users folder in the navigator and
choosing Remove from the User menu. The Remove User alert box appears.