Compare user objects - users and roles

[Michael McAuley]

Hi,

Is there any way to generate a change script that looks at the users and roles of a source and target database?

I would love that functionality....

 

[Bo Pedersen]

Yes, the Compare User Objects in the Tools menu not only shows the objects that are different but also a change script for all or the selected user objects that are different.

Bo Pedersen

 

[Michael McAuley]

The Compare user objects only has tables, views, functions etc. Is there any way to make the grants and roles and users compare?

 

[Marco Kalter]

This is currently not possible.