cannot do first time commit due to execute permission

randyvolters

I cannot login to my servers as 'sa'. What permission does my DBA need to grant me in order to do the first time commit for my databases?

Message I see is:

The EXECUTE permission was denied on the object 'RG_WhatsChanged_V1', database 'tempdb', schema 'dbo'.

Evan Moss

Hello,

Thanks for your post.

You should be all set if you run:

use [tempdb]
GRANT EXECUTE TO
<user>

use [master]
GRANT VIEW SERVER STATE TO
<user>

You'll also need alter permissions on the database you have linked to source control.

Thanks,
Evan