|
Step 7 - Editing Users
|
Learn Oracle - Editing Users
Oracle DBA can change the attributes of users by clicking Edit on the Users page (Figure 7–1)
and selecting the properties page with the attributes that Oracle DBA want to change. The
following procedure changes the tablespace quotas assigned to user MYUSER.
1. From the Users page, select MYUSER in the results list, then click Edit. The Edit
User General page is displayed.
2. Click the Quotas property page to display the Quotas page.
Oracle DBA can see that this user has 0 Mbytes quota on all tablespaces. This means that
he has no quota in any tablespace. Since MYUSER belongs to the users tablespace,
he must have quota to create tables and other schema objects in this tablespace.
3. Pull down the box in the Quota column for tablespace users. Select Value.
4. In the corresponding Value column, enter 100.
5. Click Apply.
User MYUSER can now create objects in the users tablespace.
6. Click the Database property page to return to the Administration home page.
Unlocking Accounts and Resetting Passwords
Locked accounts cannot be accessed. During installation, Oracle DBA were provided the
opportunity to unlock and reset the Oracle supplied database user accounts. If you did
not choose to unlock those accounts at that time, you can do so now as follows:
1. mark a user whose Account Status is shown as EXPIRED AND LOCKED and that you
want to unlock and reset.
2. From the pull down menu in the Actions pull-down menu, select Unlock User
and click Go. Click Yes to the confirmation message.
This unlocks the user account (the Account Status is now EXPIRED), but does not
reset the password. The user would still be unable to log in to the database.
3. From the Users page, again mark the user in the Select column, then click Edit.
The Edit User General page is displayed. Oracle DBA can also display this page for a user
by clicking the username in the UserName column.
4. Use the General page to change the password for the account. Note that Oracle DBA can
also use this page to unlock the account.
You must follow the preceding steps individually for each account that Oracle DBA want to
unlock and reset.
Locking and account is similar. You select the user and then choose Lock User from the
Actions pull-down menu. Locking an account denies access to the account.
To better understand the ramifications of unlocking and resetting accounts, see the
other property pages available on the Edit user page. Specifically, if Oracle DBA explore the
Roles, System Privileges, and Object Privileges property pages, you can see the
privileges of the user whose account you are enabling.
Granting Roles
As a system administrator, Oracle DBA can use Enterprise Manager to grant roles to users. For
example, you can grant a user the DBA role, which allows the user to administer the
database. You can also grant user-created roles, such as the APDEV role Oracle DBA created in
"Creating a New Role".
To grant the DBA role to MYUSER:
1. From the Administration Page, click Users under the Security heading.
2. From the list of users, select MYUSER and click Edit. The Edit User: MYUSER page
appears.
3. In the top navigation bar, click Roles. A page appears with the list of roles for
MYUSER.
4. Click Modify on the right hand side of the page. The Modify Roles page appears.
5. In the Available Roles list, select the DBA role and click Move to make it part of the
Selected Roles list. Oracle DBA can also select the APDEV role you created earlier in this
chapter.
6. Click OK. Then click Apply.
Revoking Roles
You can also revoke roles from users. To revoke the DBA role from MYUSER:
1. From the Administration page, click Users under the Security heading.
2. From the list of users, select MYUSER and click Edit. The Edit User: MYUSER page
appears.
3. In the top navigation bar, click Roles. A page appears with the list of roles for
MYUSER.
4. Click Modify on the right hand side of the page. The Modify Roles page appears.
5. In the Available Roles list, select the DBA role and click Remove to make it part of
the Available Roles list.
6. Click OK. Then click Apply.
|
|
|
