learn-oracle


Learn Oracle



PREVIOUS CHAPTER | NEXT CHAPTER

I have created this learn oracle "The step 10 process" Oracle Tutorial to help Database aspirants to accomplish their dream of working as Oracle Database administrator. I have tried to keep it simple and User friendly. Use NEXT and PREVIOUS Button to navaigate away and to a chapter. Since i myself had been a Database adminstrator trainer and has got real life experience of working as a Oracle DBA, I would welcome any sort of queries and doubts or modifications to webmaster@oracleonline.info.

Step 7 - Editing Users

Learn Oracle - Editing Users

Oracle DBA can change the attributes of users by clicking Edit on the Users page (Figure 71) 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.
Oracle Tutorial - BLOGS
PREVIOUS CHAPTER | NEXT CHAPTER

STEP 7 - Next Topics
For users to access your database, Oracle DBA must create user accounts and grant appropriate database access privileges to those accounts. Some user accounts are automatically included in the preconfigured database, but for security reasons, most of these accounts are locked and expired.This Step describes how to create and manage user accounts. Click on Oracle tuorial links below:
Database Administrative AccountsData Administrative Account
Administering RolesAdministering Roles
Administering ProfilesAdministering Roles
Administering Database UsersAdministering Users
Editing UsersEditing Users
Dropping Users
ORACLE DBA - DISCUSSION FORUMS
Oracle Database - PODCASTS
More Tutorials on Oracle dba ...



Liked it ? Want to share it ? Social Bookmarking
Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information


Source : Oracle Documentation | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info