Home Forums Article Discussions Article Discussions by Author Discuss content posted by Harsha Majety Script to grant exec permission to all sps in a db RE: Script to grant exec permission to all sps in a db

  • December 13, 2010 at 3:47 pm

    #1261972

    sa_11 (12/13/2010)

    J.O. (12/13/2010)

    I usually create a role and grant execute permissions to that role then assign a user to that role.

    +1

    +1

    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