Viewing and Altering Procedure Permissions

To run a stored procedure, you must have explicit permission as a user or member of a group with permission to run the procedure. This example shows you how to review and grant user and group permissions.

1. In the Procedure & Functions folder, right-click a procedure, and choose Properties.
2. Click the Permissions tab to see which users have permissions on this procedure.
3. Click Grant, choose the user or group you want to grant permission to execute this procedure, click OK.
4. Click Apply.