Red Gate SQL Source Control–Solution for users not seeing Last Changed By user names

After installing the latest version of Red Gate SQL Source Control many of our non-sys-admin users were unable to see who had made changes to a database object.

image

After reading all the documentation and applying the suggested permission changes we found that we were still lacking some of the needed permissions to get this working.  After looking through exception details in the log files we were able to get all the right permissions setup.  Use the script below to grant your user/group the necessary rights.

USE master

go

GRANT ALTER TRACE TO [UserHere]

GO

GRANT VIEW SERVER STATE TO [UserHere]

go

GRANT SELECT ON sys.sql_expression_dependencies TO [UserHere]

GO

USE tempdb

go

GRANT EXECUTE ON tempdb .dbo. RG_WhatsChanged_v4 TO [UserHere]

GO

GRANT CREATE TABLE TO [UserHere]

GO

GRANT ALTER on SCHEMA::dbo TO [UserHere]

go
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s