To grant or revoke privileges on a stored procedure:

  1. 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.

  2. Click the Permission tab. The Permission page is displayed.

  3. Select the User/Group to whom you want to grant or revoke the privilege.

  4. Click Modify.

  5. 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.

  6. Click Confirm.


Related topic:

Granting Privileges on Stored Procedures