Shown briefly in this post are the privileges that need to be granted to an Oracle User for performing Data Pump operations in a Database Vault (DV) enabled Environment.
Sign in as the DV Owner and run the following command to authorize Data Pump Operations for the user.
EXEC DVSYS.DBMS_MACADM.AUTHORIZE_DATAPUMP_USER(‘username’);
To authorize Transportable Tablespace operations, run the following command:
exec dbms_macadm.authorize_tts_user(uname,tsname);
References:
Sign in as the DV Owner and run the following command to authorize Data Pump Operations for the user.
EXEC DVSYS.DBMS_MACADM.AUTHORIZE_DATAPUMP_USER(‘username’);
To authorize Transportable Tablespace operations, run the following command:
exec dbms_macadm.authorize_tts_user(uname,tsname);
References:
- How To Export / Import Objects In Database Vault Environment (Doc ID 822048.1)