Assign create stored procedure permissions

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736222 More actions · Answer 1

GRANT ALTER ON SCHEMA::myschema to myuser

GRANT CREATE PROCEDURE TO myuser

Matt Crowley SSCarpal Tunnel Points: 4163 More actions · Answer 2

One thing to note, is that the ability to alter a schema carries the ability to drop existing objects in that schema.

DKlein SSCrazy Points: 2351 More actions · Answer 3

Thanks for the replies! Will that give the user the ability to create stored procedures on other schemas, say dbo?

Thanks again,

DK

Matt Crowley SSCarpal Tunnel Points: 4163 More actions · Answer 4

No. By default, the user will have no permissions (ALTER) on the dbo schema. Give it a whirl.

DKlein SSCrazy Points: 2351 More actions · Answer 5

SSCrazy

Points: 2351

May 6, 2014 at 11:11 am

Thanks!