Revoking Execute Permission on an Extended Stored Procedure

Revoke execute permission on extended stored procedures.

1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects, then select Extended Stored Procedures.
2. Click the Name field of the extended 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.