----------  Grant or Revoke Privilege  ----------

Table access privileges may be granted to or revoked from users/database roles
other than the owner  of the table.  The types of privilege are alter, delete,
display, drop, empty, index, insert, select, sort, or update [(ATTR {, ATTR})]. 
If no attributes  are  specified with "update", update privilege is granted on
all attributes of the table.  If attributes are specified after "update",  only
those attributes may be updated.

The syntax for the grant privilege command is:

grant PRIVILEGE {, PRIVILEGE} [on] TABLE [to] GRANTEE {, GRANTEE}
                [as GRANTOR] [[with] grant [option]];

The privilege types may be specified separately or in three groups (dba, user,
or  all).   Specifying "dba" allows alter, drop, empty, index, and sort, while
specifying "user" allows delete, display, insert, select, and update.

The GRANTEE is the name of another user/database role, or may be one of CREATOR,
DBA, PUBLIC or a defined database role name. CREATOR is the owner of the table;
DBA is the administrator of the database; and PUBLIC means all users.  GRANTOR
is either CREATOR, DBA or the name of a user; the default is the name of the 
person issuing the command.  If grant option is specified the privileged users
may grant their privileges to others.

To remove table access privileges from users other than the owner, the revoke
privilege command is used.

Syntax:

     revoke PRIVILEGE {, PRIVILEGE} [on] TABLE [from] GRANTEE {, GRANTEE}
                 [as GRANTOR];

The privileges on a table can be displayed with the DISPLAY PRIVILEGE command.
Grant  options  on  table  access privileges can be displayed with the DISPLAY
GRANT PRIVILEGE command.

For further information type:

                help display;

For further database role information type:

                help role;
