April 2, 2010 at 8:52 am
I have e developer who needs to have access to create stored procedures in the database - but I donot want to give him dbowner acess to the database. Any suggetsions?
Also is there any way to give them access so that they can only view the stored proc defintion - not edit or change it?
Thank You
SDKhan
April 2, 2010 at 9:10 am
You can grant him (her) db_ddladmin, but this would give them rights to alter/drop as well as create.
April 2, 2010 at 9:14 am
Use the db_ddladmin role instead of db_owner. Possibly even create your own database role to limit this even more.
April 2, 2010 at 9:19 am
You can grant the right to create procedures specifically.
Would look like this:
GRANT CREATE PROCEDURE TO bob;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 2, 2010 at 9:33 am
GSquared (4/2/2010)
You can grant the right to create procedures specifically.Would look like this:
GRANT CREATE PROCEDURE TO bob;
if granting the rights granularly as GSquared posted, just bear in mind that you will also need to apply ALTER permissions too on the schema the sprocs are created in 😉
This is the way i would do it!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply