Revoking Table Permissions

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

Prerequisites

To grant or revoke predicated privileges, set the configuration parameter enable predicate privileges to 1.

Task

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

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Permissions.
  4. In the right pane, select the grantee and click Revoke.
    In the Revoke Permissions window, each type of permission is listed. Currently granted permissions are indicated by a check mark. Permissions with predicated privilege are indicated by the letter "p" under a check mark.
  5. Choose one of:
    • Click Revoke all permission to revoke all permissions shown in the Revoke Permissions window.
    • Click individual cells to revoke the currently granted permissions. The cell changes to show an "x," indicating that the permission type is no longer granted.
    • Click Revoke all permission with predicate to revoke all permissions with a predicate shown in the Revoke Permissions window.
    Click Predicate to see details of the predicate search condition.
  6. (Optional) Click Preview to see the SQL statements for your command.
Related tasks
Granting Table Permissions
Granting Column Permissions
Revoking Column Permissions