What are the challenges you face when working across database platforms? Take the survey
Options

Issue upgrading to Sql Source Control 5

JK1966JK1966 Posts: 4 New member
edited October 6, 2016 10:32PM in SQL Source Control
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

Comments

  • Options
    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
    Andrew Pierce
    Technical Sales Engineer
    Redgate Software
Sign In or Register to comment.