Granting Execute Access to All Stored Procedures to a Given User

• Brian Martin

  SSC Eights!

  Points: 870

  More actions

  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.