Skip to Main Content

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!

SQL Developer - Database Diff SQL to include Grants

Vin Steele1Feb 3 2017 — edited Apr 20 2020

In SQL Developer, under the "Tools" menu, there is an option "Database Diff". It produces a report of the differences between objects in two different Oracle schema. It then allows you to generate SQL to implement the changes necessary to make the 'Target' schema objects match the 'Source' schema objects. This SQL does not include grants. I request that grants be included, at least in those objects (like materialized views) that  are dropped and recreated.

Archived, please refer to this ER in the SQL Developer Exchange instead.

Comments
Post Details
Added on Feb 3 2017
2 comments
7,704 views