6.1.11 Ensure All `SYSTEM` Privileges Are Revoked from Unauthorized 'GRANTEE'

Information

System privileges grant access to sensitive operations, such as creating or modifying database structures, managing user accounts, and accessing sensitive data.

Unauthorized users with system privileges can perform actions that bypass normal security controls, potentially leading to data breaches, tampering, or destruction.

Solution

To remediate this setting, execute the following SQL statement, keeping in mind if this is granted in both container and pluggable database, you must connect to both places to revoke. Please ensure proper impact analysis is done before revoking the privilege from a role.

REVOKE <SYSTEM PRIVILEGE> FROM <grantee>;

In the case of a grant via a role:

REVOKE <rolename> FROM <grantee>;

See Also

https://workbench.cisecurity.org/benchmarks/16474