How are the DBA, SYSDBA, SYSOPER roles and SYS, SYSTEM users related in Oracle?
1
vote
1
answer
5475
views
I don't know if I correctly understand the privileges of these built-in roles and users, but this is a list of the information that I have found:
* The DBA and SYSDBA roles enable you to do everything. If this is true, then why are there two names for the same thing?
* The SYSOPER role enables you to do everything except accessing users' data;
* The SYS user has the DBA and SYSDBA roles, so they can do anything;
* The SYSTEM user has the DBA role, so it seems that they could do anything, but I have read that they cannot do backups, recovery, and DB upgrade.
Is my understanding correct?
Asked by iwis
(113 rep)
Mar 19, 2021, 07:10 PM
Last activity: May 25, 2023, 12:00 PM
Last activity: May 25, 2023, 12:00 PM