6.2.20 Ensure 'PDB_DBA' Is Revoked From Unauthorized 'GRANTEE'

Information

The PDB_DBA privilege allows users to manage Pluggable Databases (PDBs) within a Container Database (CDB). This privilege grants the ability to create, drop, and modify PDBs.

Users with PDB_DBA can modify or delete PDBs, impacting database availability and security. Revoking this privilege from unauthorized users ensures that only authorized administrators manage PDBs, ensuring database security.

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 PDB_DBA 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: af54cd805dc7efd01e3b297ebe146839ad884596d441f145dbdd678def2877c8