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.

Select 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 table access permissions.
You see the Revoke Permissions wizard. Each type permission and the current granted permissions are shown in cells.
Choose one of:
- Click Revoke all permission.
- Click individual cells to revoke the currently granted permissions. The cell updates to show an x, indicating the permission type is no longer granted.
(Optional) Click Preview to see the SQL statement of the selected options.