To grant and revoke privileges on a table, you need the
proper authorizations:
To grant and revoke privileges on a catalog table, you need either SYSADM
or DBADM authority.
To grant and revoke privileges on a user-defined table, you need to meet
the following requirements:
To grant and revoke the CONTROL privilege, you need SYSADM or DBADM
authority.
To grant privileges other than CONTROL, you need one of the following
authorizations. To revoke privileges other than CONTROL, you need one
of the first three of these authorizations.
SYSADM authority
DBADM authority
The CONTROL privilege on the table
The privilege that you want to grant, along with the Grant option (the
right to grant this privilege to other users and groups)
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 users and groups
