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- In the left pane of the Administration Console, expand , then choose one of the following:
- Select the table for which to revoke column permissions.
- From the drop-down list, select Properties.
You see the properties view for the table you selected.
- In the left pane, click Columns.
- Select the column from which to revoke permissions.
- From the drop-down list, select Properties.
You see the properties window for the column 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.