Execute permissions error
JK1966
Posts: 4 New member
After upgrading to Sql Source Control 5 I am now receiving an error "The EXECUTE permission was denied on the object 'RG_WhatsChanged_v4', database tempdb, schema 'dbo'. I've tried unlinking my database and re-linking it but that didn't work. Any ideas on how to fix this?
Tagged:
Comments
Thanks for your post!
This is related to the "Object changed by Unknown" issue when the user does not have the appropriate permissions to view the information about who committed previously - the "Last changed by" column just says "unknown" https://documentation.red-gate.com/disp ... by+Unknown
You can get around this by asking your dba to grant you execute permissions on either Tempdb or on the 'RG_WhatsChanged_v4' object which polls the default trace to get the "Last changed by" information.
I have also followed up with you via email in case you have any further issues or questions.
Kind Regards
Technical Sales Engineer
Redgate Software
Redgate Software