cannot do first time commit due to execute permission

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

cannot do first time commit due to execute permission

Postby randyvolters » Mon Mar 17, 2014 5:04 pm

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
randyvolters
 
Posts: 2
Joined: Fri Nov 08, 2013 1:24 pm
Location: Columbia, SC

Postby Evan Moss » Wed Mar 19, 2014 9:45 pm

Hello,

Thanks for your post.

You should be all set if you run:

Code: Select all
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
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest