Execute permission denied tempdb object RG_WhatsChanges_V4
savuthu
Posts: 2
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.
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.
Tagged:
Comments
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.
Red Gate Software
US Product Support
is there a solution for this?
Best,
Technical Sales Engineer
Redgate Software
Thanks for your post.
The post written by @Andrew P to this so I hope it helps.
Kind regards
Richard Lynch.
Redgate Software