SQL Server Performance

Grant alter procedure?

Discussion in 'SQL Server 2005 General DBA Questions' started by silktaiji1, Aug 1, 2007.

  1. silktaiji1 New Member

    Does any one know how to grant users alter procedure permission without granting db_owner or ddladmin roles? I thought GRANT CREATE PROCEDURE TO USER1 would do but it doesn't, and there's no GRANT ALTER PROCEDURE option.
    Thanks for your input.
    Ben
  2. satya Moderator

  3. silktaiji1 New Member

    What about 2005? Are there new features that may be used?
    --Ben
  4. satya Moderator

    Please refer to the SQL 2005 books online in this case on CREATE PROCEDUE & GRANT topics.

Share This Page