title: SQL Server 2005 - Granting permission to create stored procedures (but no other objects)
body: <p>I want to grant a user permission to create, alter, and execute stored procedures, but without the ability to create other database objects.  I excluded them from the role db_ddladmin, but explicitly granted the permissions "Create procedure" and "Execute".  These permssions appear in the effective permissions list.  However, when I try to create a stored procedure with this login, I get the following error: </p>
  
  <p>"The specified schema name "dbo" either does not exist or you do not have permission to use it."</p>
  
  <p>Any suggestions?</p>