Learn Oracle


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 - 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 boxes.

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 user, MYUSER.

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.
Oracle Tutorial - BLOGS

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 Users
Dropping Users
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 | Return to Learn Oracle

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