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!

Privileges needed for Import and export

832104Mar 19 2012 — edited Apr 16 2013

Greetings All,

I am working on eliminating the DBA role from users in our 11g DB.

In our system, a backup of a user schema is done via an export using the user ID/PW. A .bat file is generated using the user ID and Password to execute expdp.

What privileges are needed for a user to export and import only a schema?

I am aware of EXP_FULL_DATABASE and IMP_FULL_DATABASE roles.

Are these the roles needed?

Would a user with these roles be able to export the full database (all schemas?).

I’d like to limit each user to export/import their own schema.

Thanks for your time,

Bob

Locked Post

New comments cannot be posted to this locked post.

Locked on May 14 2013

Added on Mar 19 2012

#and, #database-key-features, #export, #export-import-sql-loader-external-tables, #for, #import

6 comments

60,303 views