Dropping views
A view is dropped when the privilege that is required to create it is revoked.
Revoking the privilege on a view is not communicated to Db2 by the authorization checking
routine. If you want Db2 to
drop the view when the privilege is revoked, you must issue the SQL
REVOKE statement.