Create Stored Procedure Authority

• David Bird

  SSCarpal Tunnel

  Points: 4669

  More actions

  May 5, 2006 at 9:06 am

  #366099

  I need to allow developers to create stored procedures in a development database.  Is there an authority I can grant them that would allow them to create and alter stored procedures? 

  I thought about DB_OWNER and DB_DDLADMIN but I don't want them creating, altering, and dropping tables.

   

  David Bird

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  May 5, 2006 at 10:14 am

  #636318

  grant

  create procedure to role_name

  revoke create table to role_name