Minimum Security requirements for comparison

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.

R. Schreurs June 27, 2008 09:01

Comments

5 comments

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

Michelle T June 30, 2008 13:19

0
Thank you, this is exactly what I needed.

R. Schreurs July 03, 2008 15:54

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

R. Schreurs August 27, 2010 11:32

0
Hello,

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

Simon L October 04, 2010 03:15

0
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.

R. Schreurs February 13, 2014 06:56

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Minimum Security requirements for comparison

Comments

Add comment