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

cannot do first time commit due to execute permission

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'.
randyvolters
0

Comments

1 comment

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

Add comment

Please sign in to leave a comment.