The system automatically grants the following privileges on a newly created view to its creator:
- DELETE
- DROP VIEW
- INSERT
- SELECT
- UPDATE
To... | the user must have the... |
---|---|
create a view | CREATE VIEW privilege. |
drop or replace a view | DROP VIEW privilege. |