• Exact same question as another user posted. Interesting Coincidence.

    Answer:

    Grant CREATE PROC to a role. Put Users in that role.

    Grant ALTER SCHEMA on the schema(s) that the Users need to modify stored procedures in to the role.

    Grant VIEW DEFINITION on the schema(s) that the Users need to modify stored procedures in to the role.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events