Permissions required for Redgate SQL Source Control

Redgate SQL Source Control is a SSMS plug-in which allows you to source control your database schema. Assuming you or your users have limited access, some permissions are required to use this application.

At a database scope the VIEW DEFINITION permission is required to view code changes which have not been committed. ALTER is also required when committing code changes to your version control system (subversion, git, etc).

USE [YourDatabase]
GO
GRANT VIEW DEFINITION TO [jacobs];
GO
GRANT ALTER TO [jacobs];
GO

At a server scope ALTER TRACE is useful but not required. This enables the user(s) to see who has made schema changes under the ‘Changed by’ column in the Commit Changes tab.

USE [master]
GO
GRANT ALTER TRACE TO [jacobs];
GO

Note: This information is based off the SQL Server default trace. For busy SQL Servers the default trace can recycle often, if this is the case the ‘Changed by’ column will likely be Unknown. At present there is no way to change how much historical data the default trace contains or change which data source SQL Source Control references.


Leave a Reply

Your email address will not be published. Required fields are marked *