CODEWITHSUNDEEP
oracle-databasesql-grantdatapump
Jamie
Jamie

Reputation: 268

Oracle Revoke Invalid Grants

I'm currently in the process of migrating a database, and dropping several schemas in the move.

The schemas I'm excluding have grants on some of the schemas that are included. Like grant update on IncludedSchema.ATable to ExcludedSchema.

It doesn't appear possible to exclude these grants from the export. That was probably a choice made by the datapump devs (including all grants on the schema vs. grants given to the schema).

I want to clean these up after the migration. Is there an easy way to do that? Does anyone have a script to find and revoke grants given to grantees that do not exist?

Upvotes: 0

Views: 45

Answers (0)

Related Questions