Information
The IMP_FULL_DATABASE privilege allows users to import database objects using Oracle Import utility Unauthorized access to this privilege can lead to data corruption
A user with IMP_FULL_DATABASE can restore data, potentially leading to data corruption or security violations.
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 IMP_FULL_DATABASE FROM <grantee>;
In the case of a grant via a role:
REVOKE <rolename> FROM <grantee>;