Differences between oracle system and sys

 

Today, when a user is granted permissions, the system cannot log on to the database as sysdba, but the system can log on as sys. The differences are as follows:

Sys users have the roles or permissions of dba, sysdba, and sysoper. You can only log on to em as sysdba or sysoper.

System users have common dba roles or permissions, and can only log on in the normal form, unless sysdba permissions are granted

 

Log on to oracle as a sys user and run select * from v _ $ pwfile_users to view users with sysdba permissions.

 

From yangaming's column