SQL Developer - Database Diff SQL to include Grants

Vin Steele1

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.

Sven W.

I agree with the suggestion, however this is not the proper space for SQL Developer related ideas.

The proper forum would be the SQL Developer exchange. And here is the direct link to the feature request page filtered on the DIFF tool

https://apex.oracle.com/pls/apex/f?p=43135:6::::RIR:IR_PRODUCT,IR_COMPONENT:SqlDev,Diff

There is already an accepted idea called "compare permissions". Feel free to vote for it or leave a comment.

https://apex.oracle.com/pls/apex/f?p=43135:7:::NO:RP,7:P7_ID:21521

Gbenga Ajakaye

Umm, it's funny that my current project where using both SQL Develeoper and DBArtisan. We had to use DBArtisan to grab all grant DDL for a schema. The only thing that is remotely similar in SQL Developer is to CREATE LIKE; which is just really grant privilege name BLANK. I'll love to see this functionality too.