6.1.3 Ensure 'IMPORT' And 'EXPORT' 'FULL DATABASE' Is Revoked From Unauthorized 'GRANTEE'

Information

The EXPORT FULL DATABASE and IMPORT FULL DATABASE privileges in Oracle Database allow users to perform full database exports and imports, which can lead to data exfiltration, unauthorized modifications, and compliance violations if granted to unauthorized users.

An unauthorized user with EXPORT FULL DATABASE privilege could create a full backup of the database and move it to another location. An unauthorized user with IMPORT FULL DATABASE privilege can overwrite, inject, or alter critical database 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 IMPORT FULL DATABASE FROM <grantee>;
REVOKE EXPORT FULL DATABASE 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: 0a2ab3d51c5c2bc4812d8ff9f25e81c38ace4c90012bf9fdef4a707cd6363b71