To grant and revoke privileges on a view, you need the
proper authorizations:
To grant and revoke privileges on a catalog view, you need either SYSADM
or DBADM authority.
To grant and revoke privileges on a user-defined view, 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 view
The privilege that you want to grant, along with the Grant option (the
right to grant the privilege to other users and groups)
Example
You can grant the ALTER privilege on a user-defined view if you hold one of
these authorizations:
SYSADM authority
DBADM authority on the database in which the view resides
The CONTROL privilege on the view
The ALTER privilege, along with the right to grant the ALTER privilege on
this view to other users and groups
