Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Tim Mitchell Granting Execute Access to All Stored Procedures to a Given User RE: Granting Execute Access to All Stored Procedures to a Given User

  • March 25, 2007 at 6:57 pm

    #696795

     

    To grant execute permissions to a user for all stored procs in a schema. Using the GUI

     

    Right click a stored proc.

                Click properties

    Click view schema permissions

    Add

                Object type -> user -> ok

    Brows

                Choose user -> ok

     

    Click on the user

                Under grant check execute.