EXECUTE permission denied on RG_WhatsChanged_v3

jrphifer

“The EXECUTE permission was denied on the object ‘RG_WhatsChanged_v3’, database ‘tempdb’, schema ‘dbo’.

Since this object and others related are created in the tempdb and are therefore temporary how do they get recreated and permissions assigned. Every time we reboot SQL Server the developers loose execution permission on this stored proc.

How do we fix this?


Thanks.

Gareth_B

Would it be possible to set up a separate database for these objects, rather than using tempdb?

If that's an option, SQL Source Control can be configured to use that database (this will have to be done for each of your developers).

Instructions for how to set this up can be found here: http://documentation.red-gate.com/displ ... +databases