Revoking Permissions on Database Objects

Revoke permissions on objects such as stored procedures, functions, extended stored procedures, and views.

1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects, then select Procedures.
2. Click the Name field of the object on which to revoke permissions.
3. Click the drop-down arrow and select Properties.
4. Select Permissions.
5. 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.
6. 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.
7. (Optional) Click Preview to see the SQL statements for your command.