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