Post reply

Need to give user modify permission SQL 2005

  • March 31, 2009 at 8:34 am

    #155488

    I have a user who can execute a stored procedure. I need to give this user modify permission.

    I don't know if I'm missing something obvious, but I tried doing it from the stored procedure properties, then from the user's properties. I see the execute permission in both places, but can't figure out how to add more permissions?

    How do I do this?

  • March 31, 2009 at 4:14 pm

    #969544

    Grant ALTER SCHEMA on the schema(s) that the developers need to modify stored procedures in to the role. Add the developers to this newly created role.

    MJ

Viewing 2 posts - 1 through 1 (of 1 total)

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