Minimum Security requirements for comparison

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Minimum Security requirements for comparison

Postby R. Schreurs » Fri Jun 27, 2008 2:01 pm

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
 
Posts: 12
Joined: Fri May 04, 2007 2:28 pm
Location: Netherlands

Postby Michelle Taylor » Mon Jun 30, 2008 6:19 pm

Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

Excellent

Postby R. Schreurs » Thu Jul 03, 2008 8:54 pm

Thank you, this is exactly what I needed.
R. Schreurs
 
Posts: 12
Joined: Fri May 04, 2007 2:28 pm
Location: Netherlands

Explanation has disappeared

Postby R. Schreurs » Fri Aug 27, 2010 4:32 pm

The link is now invalid, reporting status 404. Is the information still available somewhere?
R. Schreurs
 
Posts: 12
Joined: Fri May 04, 2007 2:28 pm
Location: Netherlands

Postby Simon Lye » Mon Oct 04, 2010 8:15 am

Hello,

Sorry about that - we've updated the link above, is that what you were after?
Red Gate
Simon Lye
 
Posts: 24
Joined: Thu Jan 18, 2007 1:00 pm
Location: Red Gate Software

Documentation has moved

Postby R. Schreurs » Thu Feb 13, 2014 12:56 pm

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
 
Posts: 12
Joined: Fri May 04, 2007 2:28 pm
Location: Netherlands


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron