Execute permissions error

JK1966JK1966 Posts: 4 New member
edited October 7, 2016 5:23PM in SQL Source Control Previous Versions
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:
· Share on Twitter

Comments

  • Andrew PAndrew P Posts: 194 Silver 3
    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
    · Share on Twitter
  • 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.
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    This object is created automatically by SQL Source Control.
    Software Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.