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'.
Randy Volters
Data Acquisition Architect
Seibels Insurance and Technology Services

Comments

  • 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
    Product Support
    (866) 627-8107
Sign In or Register to comment.