exp/imp privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: exp/imp privileges

  1. #1
    Join Date
    Nov 2000

    Lightbulb exp/imp privileges

    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?


  2. #2
    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.

  3. #3
    Join Date
    Nov 2000
    Thanks! I realized that this can't be done without the two roles across schemas other than the way you mentioned.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width