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
   

   silktaiji1, Aug 1, 2007

   #2
2. satya Moderator

   If its on SQL 2000 then nothing you can do for that as per http://msdn2.microsoft.com/en-us/library/Aa258909(SQL.80).aspx information.
   

   satya, Aug 1, 2007

   #3
3. silktaiji1 New Member

   What about 2005? Are there new features that may be used?
   --Ben
   

   silktaiji1, Aug 1, 2007

   #4
4. satya Moderator

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

   satya, Aug 1, 2007

   #5

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in