Who Can Alter a View?
The ALTER VIEW
statement can be executed by:
-
The owner of the view
-
Users with the
ALTER ANY VIEW
privilege
The ALTER VIEW
statement can be executed by:
The owner of the view
Users with the ALTER ANY VIEW
privilege
ALTER VIEW
PRICE_WITH_MARKUP
ALTER VIEW PRICE_WITH_MARKUP (
CODE_PRICE,
COST,
COST_WITH_MARKUP
) AS
SELECT
CODE_PRICE,
COST,
COST * 1.15
FROM PRICE;