Revoke system privileges from roles.
Prerequisites
See Enabling Granular Permissions.
Task- In the Perspective Resources view, select the server on
which the role resides, then click the drop-down arrow next to the server name and
select Administration Console.
- In the left pane of the Administration Console, expand .
- Select a role from which to revoke privileges.
- From the drop-down list, select Properties.
You see the properties window for the role you selected.
- In the right pane, click the Database
drop-down list and select the database from which you want to revoke privileges.
- Select one or more privileges and click Revoke.