Oracle Supplied Administrator Accounts

Oracle Supplied Administrator Accounts

In this article, I am going to discuss Oracle Supplied Administrator Accounts with Examples. Please read our previous article where we discussed Information about User Accounts in Oracle with Examples.

Oracle Supplied Administrator Accounts

When we create a database oracle will create a few users and those users have special privileges to perform certain tasks. There are administrator accounts like sys and system and there are many other administrator accounts.

SYS: This account can perform all administrative functions. This is the highest user account and the special user account. All base tables and views for the database data dictionary are stored in the SYS schema. These base tables and views are critical for the operation of the 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.

Note: You must not create any tables in the SYS schema. We have created some tables before in sys schema but never do that in the production database or any environment database. The SYS user is granted the SYSDBA privilege, which enables a user to perform high-level administrative tasks such as backup and recovery.

The SYSDBA is one of the special privileges. The SYS user owns the SYSDBA privilege.

System: This account is the same as the SYS user but with fewer privileges. This account performs all the operations the SYS does but cannot perform the following operations:

  • Backup and Recovery
  • Database Upgrade

This is the difference between the SYS and the system user.

SYSBACKUP: The user SYSBACKUP facilitates Oracle Recovery Manager (RMAN) backup and recovery operations. This user is used to take backups in the oracle database.

SYSDG: Facilitates Oracle Data Guard Operations. Oracle Data Guard provides the management, monitoring, and automation software to create and maintain one or more standby databases to protect Oracle data from failures, disasters, human error, and data corruption while providing high availability for mission-critical applications. Data Guard is included with Oracle Database Enterprise Edition.

SYSKM: This user is responsible for Transparent Data Encryption Wallet Operations. Transparent Data encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces.

SYSRAC: This used is for Real Application Cluster (RAC) database administration tasks. This user is used in the RAC cluster where multiple instances are used for high availability.

SYSMAN: This user is used in Oracle Enterprise Manager database administration tasks.

In the next article, I am going to discuss Special System Privileges for Administrators in Oracle with Examples. Here, in this article, I try to explain Oracle Supplied Administrator Accounts with Examples. I hope you enjoy this Oracle Supplied Administrator Accounts article.

Leave a Reply

Your email address will not be published. Required fields are marked *