exp/imp privileges

[Unna]

Dear all,

A user needs to export and import other schema objects; however, I do not want to give this user dba nor exp_full_database and imp_full_database roles. These exp_full_database and imp_full_database roles have too many system privileges, such as drop and create user, and drop any objects privileges. These are privileges that non dba user doesn't need or can do harm to the database.

Can anyone provide me a list of privileges that are just enough for a user to exp and imp other schema objects?



Thanks,
Unna

[jhmartin]

The only other oracle-centric alternative is to give them the password to the other scheme objects as you need either direct access to the schema or those privileges.

A non-oracle way to do it is to create a UNIX 'sudo' task for them that allows them to invoke imp(dp) / exp(dp) with certain predefined options as a privileged user.

[Unna]

Thanks! I realized that this can't be done without the two roles across schemas other than the way you mentioned.