V-270528

Discussion

System privileges can be granted to users and roles and to the user group PUBLIC. All privileges granted to PUBLIC are accessible to every user in the database. Many of these privileges convey considerable authority over the database and should be granted only to those persons responsible for administering the database. In general, these privileges should be granted to roles and then the appropriate roles should be granted to users. System privileges must never be granted to PUBLIC as this could allow users to compromise the database.

Check Content

To determine the current setting run the SQL statement:

sqlplus connect as sysdba

SELECT con_id, privilege
FROM sys.cdb_sys_privs 
WHERE grantee = 'PUBLIC'
ORDER BY 1,2;

System privileges are not granted to PUBLIC by default and would indicate a custom action.

If any records are returned, this is a finding.