Hello,

Oracle Database Privileges

A user can connect with different levels of privileges:

1. Namely for the database:

SYSDBA (the root or administrator of the database) and

SYSOPER – SYSOPER allows a user to perform basic operational tasks, but without the ability to look at user data.

2. For Automatic Storage Management:

SYSASM (the root or administrator of Automatic Storage Management)

Administrative Privileges

Administrative privileges that are required for an administrator to perform basic database operations are granted through two special system privileges, SYSDBA and SYSOPER. You must have one of these privileges granted to you, depending upon the level of authorization you require.

SYSDBA and SYSOPER

The following operations are authorized by the SYSDBA and SYSOPER system privileges:

The privileges of SYSOPER are:

  • Perform STARTUP and SHUTDOWN operations
  • CREATE SPFILE
  • ALTER DATABASE OPEN/MOUNT/BACKUP
  • ALTER DATABASE ARCHIVELOG
  • ALTER DATABASE RECOVER (Complete recovery only. Any form of incomplete recovery, such as UNTIL TIME|CHANGE|CANCEL|CONTROLFILE requires connecting as SYSDBA.)
  • Includes the RESTRICTED SESSION privilege

Credits: TekSlate