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!

full exp/imp sys priveleges

Ora_83Apr 2 2018 — edited Apr 6 2018

Hello

After full database export/import, the privileges on sys schemas are missing on the schemas.
ie.
grant execute on dbs_lock to user1;

Whats the best practice to perform full exp/imp to overcome this issue ? I know i can run "select dbms_metadata.get_granted_ddl" on the source database for each schema but was wondering if there is an easier way ?

Regards

This post has been answered by Mark D Powell on Apr 3 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2018

Added on Apr 2 2018

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

5 comments

2,518 views