How can I compare a user's privileges between 2 databases to determine the differences using the Toad compare utility?
Both users have the same name but exist on 2 different databases.
SOLUTION 1:
In Schema Browser | User, right click on the user and choose to "Compare with another object".
SOLUTION 2:
Once the compare is finished, the results tab, under “Objects which differ” should show only one username and note the differences between the users.
The toolbar within in the Result tab has options that allow you to compare differences and view sync script to further review the specific differences.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center