Revoking Execute Permission on a Stored Procedure

Revoke execute permission on stored procedures.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects, then select Stored Procedures.
  2. Click the Name field of the stored procedure, then click the drop-down arrow and select Properties.
  3. In the left pane, click Permissions.
  4. Select the grantee, then click Revoke to revoke access permissions to the object.
    In the Revoke Permissions wizard, each type of permission and the current granted permissions are shown in cells.
  5. Choose one of:
    • Revoke all permission.
    • Individual cells to revoke the currently granted permissions. The cell changes to show an "x", indicating that the permission type is no longer granted.
  6. Click OK.