Execute permission denied tempdb object RG_WhatsChanges_V4

savuthu

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.

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.

bbroussard

I am having the same issue. Only users with sysadmin rights do not get this error.

is there a solution for this?

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,

FisherJoe

Has this been resolved yet? I am getting this issue on source control 6 and both DBAs are wanting to know why.

RichardL

Hi @FisherJoe

Thanks for your post. 

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

Kind regards

Richard Lynch.