Issue upgrading to Sql Source Control 5

JK1966

After upgrading to Sql Source Control 5 when I click on the "Commit" tab I receive an error.

The EXECUTE permission was denied on the object 'RG_WhatsChanged_v4' database tempdb, schema 'dbo'

what can I do to fix this

Andrew P

Hey JK,

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