Who Can Drop a View?
The DROP VIEW
statement can be executed by:
-
The owner of the view
-
Users with the
DROP ANY VIEW
privilege
The DROP VIEW
statement can be executed by:
The owner of the view
Users with the DROP ANY VIEW
privilege
PRICE_WITH_MARKUP
viewDROP VIEW PRICE_WITH_MARKUP;