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.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Click the Name field of the table, then click the drop-down arrow and select
Properties.
- In the left pane, click Permissions.
- 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.
- 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.
- (Optional) Click Preview to see the SQL statements for
your command.