Red Gate forums :: View topic - Minimum Security requirements for comparison
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Minimum Security requirements for comparison

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
R. Schreurs



Joined: 04 May 2007
Posts: 12
Location: Netherlands

PostPosted: Fri Jun 27, 2008 2:01 pm    Post subject: Minimum Security requirements for comparison Reply with quote

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.
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 528
Location: Red Gate Software

PostPosted: Mon Jun 30, 2008 6:19 pm    Post subject: Reply with quote

http://www.red-gate.com/supportcenter/Content.aspx?c=SQL_Compare%5cknowledgebase%5cSC_Permissions_Required.htm&p=SQL%20Compare
Back to top
View user's profile Send private message
R. Schreurs



Joined: 04 May 2007
Posts: 12
Location: Netherlands

PostPosted: Thu Jul 03, 2008 8:54 pm    Post subject: Excellent Reply with quote

Thank you, this is exactly what I needed.
Back to top
View user's profile Send private message
R. Schreurs



Joined: 04 May 2007
Posts: 12
Location: Netherlands

PostPosted: Fri Aug 27, 2010 4:32 pm    Post subject: Explanation has disappeared Reply with quote

The link is now invalid, reporting status 404. Is the information still available somewhere?
Back to top
View user's profile Send private message
Simon Lye



Joined: 18 Jan 2007
Posts: 24
Location: Red Gate Software

PostPosted: Mon Oct 04, 2010 8:15 am    Post subject: Reply with quote

Hello,

Sorry about that - we've updated the link above, is that what you were after?
_________________
Red Gate
Back to top
View user's profile Send private message
R. Schreurs



Joined: 04 May 2007
Posts: 12
Location: Netherlands

PostPosted: Thu Feb 13, 2014 12:56 pm    Post subject: Documentation has moved Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group