Compare Roles not including object grants

Toad for Oracle - Beta
1

When I do a compare roles either from SB or from DB/compare/single objects, Toad doesn't appear to be including object grants as part of the compare. This looks to be the case in 13.x and 14. Toad 12.12 includes objects in the role compare as expected. Thanks

2

Thanks Michael. I see that. Seems like it should at least be an option. I'll log it. Unfortunately, it's too late to fix this for 14.0

As a workaround, if you have DBA module, you can use Compare Databases.

image
image954×685 41.2 KB

image
image881×746 47.1 KB

Then double-click the role of interest to see the diffs.

To get the Sync script for just that one role:

  1. right-click and uncheck all
  2. check the one you want
  3. go to Sync Script tab.