Post reply

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.

     

     

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply