Revoke database object permissions
from a role.
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 .
- Click the Name field of the role, then click the drop-down arrow and select
Properties.
- In the left pane, click Object Permissions.
- In the right pane, click the Database drop-down list and
select the database on which you want to revoke permissions from the role.
- In the right pane, click the drop-down list and select an object type to
filter the objects.
- 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 privileges 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.