6.2.21 Ensure 'SELECT_CATALOG_ROLE' Is Revoked From Unauthorized 'GRANTEE'

Information

The Oracle database SELECT_CATALOG_ROLE provides SELECT privileges on two-thirds of data dictionary views held in the SYS schema. Unauthorized grantees should not have that role.

Permitting unauthorized access to the SELECT_CATALOG_ROLE can allow the disclosure of multiple but not all dictionary data.

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 SELECT_CATALOG_ROLE FROM <grantee>

In the case of a grant via a role:

REVOKE <rolename> FROM <grantee>;

See Also

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

Item Details

Category: ACCESS CONTROL, MEDIA PROTECTION

References: 800-53|AC-3, 800-53|AC-5, 800-53|AC-6, 800-53|MP-2, CSCv7|14.6

Plugin: OracleDB

Control ID: c30d41ae0a41ed582dbe77ee839524934b4facbe6bf865e0431f6aceb15976c4