08/12: oracle sys system difference
Category: Oracle
Posted by: hajime osako
Oracle
SYS owns the data dictionary
SYS has the SYSDBA privilege which SYSTEM doesn't
Note, SYSDBA is not a role, it is a privilege. You'll find it in system_privilege_map, not in dba_roles.
SYS owns the data dictionary
SYS has the SYSDBA privilege which SYSTEM doesn't
Note, SYSDBA is not a role, it is a privilege. You'll find it in system_privilege_map, not in dba_roles.