Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant Privileges in Database Vault for DATAPUMP.

VIRUFeb 28 2012 — edited Mar 1 2012

HI,

I am using ORACLE DATABASE 11g R2.
I have installed/enabled DATABASE VAULT 11g on it.

I have configured many user in it for privileges like 'SELECT on table','INSERT on table' ,DELETE .....

I want to give a user DATAPUMP privilege so that he can export and import.

I have 2 users.

1) MAIN
2) BACKUP

MAIN user is the owner and the most important schema. Now i want one more schema named 'BACKUP' which will be able to take backup from MAIN schema. NO OTHER SCHEMA SHOULD BE ALLOWED TO TAKE BACKUP OF MAIN SCHEMA NOT EVEN SYS.

*Can anyone tell me how i can grant proper privilege to BACKUP schema so that he can use DATAPUMP and import/export from OS prompt on the MAIN schema.

NOTE :- I have Database vault installed on my server. Please let me know what all RULES or RULE SETS I need to make to make this happen.

Thanks in advance.