Toad World® Forums

Compare Roles not including object grants

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

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.

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.