The following should be able to extract all the grants given from a particular schema to the other schemas.
This is particular useful when you have a bunch of schemas (with cross grants) and you are planning to move schema by schema and then finally apply the grants when all schemas are moved over.
expdp \'/ as sysdba\' schemas=scott dumpfile=scott_role.dmp nologfile=yes include=owner_grant
impdp \'/ as sysdba\' dumpfile=scott_role.dmp sqlfile=scott_role.sql nologfile=yes
No comments:
Post a Comment