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 - Database Administrative Accounts

Learn Oracle - Database Administrative Accounts

Two user accounts are automatically created when Oracle Database is installed:




When Oracle DBA create an Oracle Database, the user SYS is automatically created and granted the DBA role.

All base tables and views for the database data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. They should never be modified by any user or database administrator, and no one should create any tables in the schema of user SYS. (However, Oracle DBA can change the storage parameters of the data dictionary settings if necessary.)

Ensure that most database users are never able to connect to Oracle Database using the SYS account.


When Oracle DBA create an Oracle Database, the user SYSTEM is also automatically created and granted the DBA role.

The SYSTEM username is used to create additional tables and views that display administrative information, and internal tables and views used by various Oracle Database options and tools. Never use the SYSTEM schema to store tables of interest to nonadministrative users.

A predefined DBA role is automatically created with every Oracle Database installation. This role contains most database system privileges. Therefore, the DBA role should be granted only to actual database administrators. The DBA role does not include the SYSDBA or SYSOPER system privileges.

Administrative Privileges

Administrative privileges that are required for an administrator to perform basic database operations, such as creating the database and instance startup and shutdown, are granted through two special system privileges, SYSDBA and SYSOPER. Oracle DBA must have one of these privileges granted to Oracle DBA, depending upon the level of authorization Oracle DBA require.

The SYSDBA and SYSOPER privileges can also be thought of as types of connections that enable Oracle DBA to perform certain database operations for which privileges cannot be granted in any other fashion. For example, Oracle DBA if Oracle DBA have the SYSDBA privilege, Oracle DBA can connect to the database by specifying CONNECT AS SYSDBA.
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 Roles
Administering Profiles
Administering Database 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