Home Forums SQL Server 2008 Security (SS2K8) Grant create proc permission to a user-defined role RE: Grant create proc permission to a user-defined role

  • January 1, 2013 at 4:36 pm

    #1572716

    n.heyen (1/1/2013)

    So the ALTER AUTHORIZATION statement made the [Developers] the owners of the schema?

    Exactly.

    Then I don't really need to add the rest of the GRANT statements since they are now the owners of their schema.

    Almost. You will still need to grant to the Developers role the CREATE PROC permission which is at the database level not the schema level:

    GRANT CREATE PROCEDURE TO [Developers]

    GO

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato