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. |