Revoking Table Permissions

Revoke table access permissions from users, groups, or roles.

Table owners and database owners can revoke database object permissions from a table.

In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
- User Tables
- Proxy Tables
Select the table that contains the permissions to revoke.
Select Properties.
Select Permissions.
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.
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.
(Optional) Click Preview to see the SQL statements for your command.