Revoke database object permissions
from a user.
Prerequisites
To grant or revoke predicated privileges, set the configuration parameter
enable predicate privileges to 1.
- In the left pane of the Administration Console, expand .
- Select the user from which to revoke object permissions.
- From the drop-down list, select Properties.
You see the properties window for the user you selected.
- In the left pane, click Object Permissions.
- In the right pane, click the drop-down list and select an object type to filter the objects
listed below.
- Select the object from which to revoke permission, then 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.