Database Administrator Usernames

Published by LakshmiSaahul,Dhana Royal

Database Administrator Usernames

Two user accounts are automatically created with the database:

SYS (default password: CHANGE_ON_INSTALL)
SYSTEM (default password: MANAGER)

When any database is created, the user SYS is automatically created and granted the DBA role.

All of the base tables and views for the database's data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by Oracle. 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, you can change the storage parameters of the data dictionary settings if necessary.)

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

When a database is created, 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 options and tools. Never create in the SYSTEM schema tables of interest to individual users.

SYSDBA

Perform STARTUP and SHUTDOWN operations

• ALTER DATABASE: open, mount, back up, or change character set

• CREATE DATABASE

• CREATE SPFILE

• ARCHIVELOG and RECOVERY

• Includes the RESTRICTED SESSION privilege

Effectively, this system privilege allows a user to connect as user SYS.

SYSOPER

• Perform STARTUP and SHUTDOWN operations

• CREATE SPFILE

• ALTER DATABASE OPEN/MOUNT/BACKUP

• ARCHIVELOG and RECOVERY

• Includes the RESTRICTED SESSION privilege

This privilege allows a user to perform basic operational tasks, but without the ability to look at user data

Advertising