Minimum Security requirements for comparison

R. Schreurs

I would like to know which are the minimum security requirements for SQL Compare to be able to read all object defintions in a database during the comparison. I expect this to be something like a Database role for the user that logs in. I understand that system administrators and db_owners can do this, but I would like to know the minimum required.
We would like to allow developers to be able to perform comparisons, but not be able to do the synchronization. It would be nice if this can be achieved using database roles rather than server roles, as that would allow differentation for databases on the same server.

Michelle T

http://www.red-gate.com/supportcenter/C ... %20Compare

R. Schreurs

Thank you, this is exactly what I needed.

R. Schreurs

The link is now invalid, reporting status 404. Is the information still available somewhere?

Simon L

Hello,

Sorry about that - we've updated the link above, is that what you were after?

R. Schreurs

Documentation has moved and can now be found at:
Permissions required to use SQL Compare

For Data Compare at:
Minimum database permissions for SQL Data Compare

Replace /SC10/ or /SDC10/ in the URL to correspond with the version you use.