Oracle 12c: Datapump - privilege EXP_FULL_DATABASE required?
Hi all ,
we are having two databases - both Oracle 12c but different patch levels - in which the user OPERATOR requires different privileges to export data. In the database with the lower patchlevel the privilege EXP_FULL_DATABASE is required, in the database with the higher patchlevel this privilege is not required. Below the comparison of both databases.
| TYP | GRANTEE | PRIV | AD | TABNM | COLNM | OWNER | TYP | GRANTEE | PRIV | AD | TABNM | COLNM | OWNER | |
| ROLE | OPERATOR | EXP_FULL_DATABASE | NO | -- | -- | -- | ||||||||
| ROLE | OPERATOR | OPERATOR_ROLE | NO | -- | -- | -- | ROLE | OPERATOR | OPERATOR_ROLE | NO | -- | -- | -- | |
| SYSTEM | OPERATOR |
0