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!

expdp for non dba

yxes2013Jul 25 2013 — edited Jul 27 2013

HI all,

11.2.0.1

Aix 6.1

I am a dba and I am used to export tables using "oracle" ID in aix which has by default dba privilege. The dump will go to by default to the DATA_PUMP_DIR.

My question is how can I grant access to a non-dba user who has "user01" Aix id to this DATA_PUMP_DIR, So that she can import it to her oracle schema "user01".

Do I need to member her in dba group on unix? But this can be a security breach since she is a developer only and he can become dba?

Thanks a lot,

zxy

This post has been answered by Richard Harrison . on Jul 27 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2013

Added on Jul 25 2013

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

15 comments

1,986 views