Execute permissions error

JK1966JK1966 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

  • 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
  • gjwgjw Posts: 3 New member
    Andrew, How is this object created. I see it's down as being owned by me but I can't find any scripts that I've run to explicitly create it.
  • This object is created automatically by SQL Source Control.
    Software Engineer
    Redgate Software
Sign In or Register to comment.