Dropping views

In Db2, when a privilege required to create a view is revoked the view is dropped.

About this task

Like the revocation of plan privileges, such an event is not communicated to Db2 by the authorization checking routine.

If you want Db2 to drop the view when a privilege is revoked, use the SQL statement DROP VIEW.