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

EXECUTE permission denied on RG_WhatsChanged_v3

“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.
jrphifer
0

Comments

1 comment

Sort by
  • 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
    Gareth_B
    0

Add comment

Please sign in to leave a comment.