How can we help you today? How can we help you today?

Execute permission denied tempdb object RG_WhatsChanges_V4

We keep getting the error The EXECUTE permission denied on the object "RG_WhatsChanged_v4", database tempdb, schema 'DBO' on commit changes tab. We use shared database model.

In the past we resolved this by dropping the tempdb procedure and one time we all upgraded to the same version and that seemed to have resolved it. This is the third time we are running into this issue, it seems to me that the tempdb procedure is orphaned by a redgate session. When we don't see this procedure hanging in tempdb, everything works fine.
savuthu
0

Comments

5 comments

Sort by
  • Allen LeVan
    Hello,

    Sorry for the issue you're running into with SQL Source Control and permissions on tempdb. We've opened a support ticket for you so we can troubleshoot this issue. We'll be responding through that ticket shortly, thanks.
    Allen LeVan
    0
  • bbroussard
    I am having the same issue. Only users with sysadmin rights do not get this error.

    is there a solution for this?
    bbroussard
    0
  • Andrew P
    The easiest thing to do in this instance, is to grant the User Execute permissions on Tempdb, or on that specific object.

    Best,
    Andrew P
    0
  • FisherJoe
    Has this been resolved yet? I am getting this issue on source control 6 and both DBAs are wanting to know why.
    FisherJoe
    0
  • RichardL
    Hi @FisherJoe

    Thanks for your post. 

    The post written by @Andrew P to this so I hope it helps. 

    Kind regards

    Richard Lynch. 
    RichardL
    0

Add comment

Please sign in to leave a comment.