To
grant or revoke privileges on a stored procedure:
Open the Stored Procedure node and then select the stored procedure that is to be executed. The stored procedure Properties page is opened.
Note: Double clicking on the Stored Procedure node from the tree also displays the Properties window.
Click the Permission tab. The Permission page is displayed.

Select the User/Group to whom you want to grant or revoke the privilege.
Click Modify.
Click the Execute column beside the User/Group to grant the execute privilege. A check mark indicates that the user has the execute privilege. By clicking on it again, you can revoke the privilege.
Click Confirm.
Related topic: