Description of the illustration grantandrevoke1.gif

This graphic starts with fields to select first Object Type, then Schema, Then there are buttons to select what the grant revoke privileges are to be used for, as described in the text. Then there is an Object Name field with a select list, a User/Role choice of either User or Roles. Depending on that choice, a field of available choices, (users in this case or roles) appears. Then there is a grid with privileges to provide to the users or roles. The grid columns (for users) are Privileges, Grant, and With Grant option. The cells are described in the privileges section of the table below.