Post reply

Permissions - Stored Procedures

  • January 19, 2007 at 8:33 am

    #117071

    Hi all,

    What's the least amount of privileges I can get away with for someone who needs to be able to create stored procedures on a given database?

    Cheers.

  • January 19, 2007 at 8:44 am

    #684335

    In 2000 it was db_ddladmin.  I don't know if it has changed in 2005.

  • January 19, 2007 at 8:53 am

    #684339

    Thanks Ninja,

    I was wondering if I could grant the developer the 'create procedure' permission under the properties of the database and permissions page?  Or am i barking up the wrong tree 🙂

  • January 19, 2007 at 8:57 am

    #684344

    I never had to test that but I would assume it would work.  can you test and let us know how it goes?

  • January 19, 2007 at 9:10 am

    #684351

    From memory, the CREATE PROCEDURE permisson will only allow you to create MyUserName.MyProc - you won't be able to create dbo.MyProc.

    John

  • January 19, 2007 at 9:16 am

    #684353

    Thanks to you both.

    I'll let you know if it works, otherwise it's the db_ddladmin role.

  • January 22, 2007 at 6:38 am

    #684665

    If you make use of database roles and have your stored procedures owned by the role you can get away with just giving create stored procedure permission.

  • January 25, 2007 at 4:38 am

    #685473

    Thanks John & Ninja... I haven't had time yet to test fully but I have given the developer in question db_ddladmin permission and that's good enough. 

Viewing 8 posts - 1 through 7 (of 7 total)

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