To grant or revoke privileges on tables or views, you
need the proper authorizations:
To grant or revoke privileges on catalog tables and views, you need either
SYSADM or DBADM authority.
To grant or revoke privileges on user-defined tables and views, you need
to meet the following requirements:
To grant the CONTROL privilege on a table or view, you need SYSADM or
DBADM authority.
To grant table or view privileges other than CONTROL, you need one of the
following authorizations. To revoke table or view privileges other than
CONTROL, you need one of the first three of these authorizations:
SYSADM authority
DBADM authority
The CONTROL privilege on the tables or views that you want to grant
privileges on
The privilege that you want to grant, with the Grant option (the right to
grant the privilege to other groups and users)
Example
You can grant the ALTER privilege on a user-defined table if you hold one
of these authorizations:
SYSADM authority
DBADM authority on the database in which the table resides
The CONTROL privilege on the table
The ALTER privilege, along with the right to grant the ALTER privilege on
this table to other groups and users
