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