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!

Exclude Object Grants for a specific user in a Schema Import

sql_coderFeb 3 2017 — edited Feb 9 2017

Hello,

I got an datapump schema export from database A, lets say from User_A. Now I want to import the schema in another database B. Inside of the dump are some objects SELECT grants to User_B, User_C and User_D for table X (Owner of the table is User_A, thats why the Grants are inside the export file). Is there a way to exclude those SELECT Grants for table x, when importing the schema dump ?

sql_coder

This post has been answered by Rob the Real Relic on Feb 3 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2017

Added on Feb 3 2017

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

8 comments

6,800 views