The system automatically grants the following privileges on a newly created view to its creator:
- DELETE
- DROP VIEW
- INSERT
- SELECT
- UPDATE
| Goal | Privileges User Needs |
|---|---|
| Create view | CREATE VIEW privilege. |
| Drop or replace view | DROP VIEW privilege. |