Need to give Developer access to create stored procs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Need to give Developer access to create...

Need to give Developer access to create stored procs

Rate Topic

Display Mode

Topic Options

Author

Message

skhan-680833

Posted Friday, April 02, 2010 8:52 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, August 12, 2010 10:47 AM
Points: 24, Visits: 58

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

Post #895688

Lynn Pettis

Posted Friday, April 02, 2010 9:10 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,588, Visits: 27,375

You can grant him (her) db_ddladmin, but this would give them rights to alter/drop as well as create.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #895705

DBA_Dom

Posted Friday, April 02, 2010 9:14 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 9:48 AM
Points: 563, Visits: 58,787

Use the db_ddladmin role instead of db_owner. Possibly even create your own database role to limit this even more.

Post #895710

GSquared

Posted Friday, April 02, 2010 9:19 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

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

Post #895718

Perry Whittle

Posted Friday, April 02, 2010 9:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:51 AM
Points: 5,201, Visits: 11,146

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 Wink

This is the way i would do it!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #895745

« Prev Topic | Next Topic »

Permissions