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 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: