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:
- Select the table that contains the permissions to revoke.
- From the drop-down list, select Properties.
You see the properties view for the table you selected.
- In the left pane of the Properties view, 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.