View Privileges
Go Up to Types of Views: Read-only and Update-able
The creator of the view must have the following privileges:
- To create a read-only view, the creator needs
SELECTprivileges for any underlying tables. - To create an update-able view, the creator needs
ALLprivileges to the underlying tables.
For more information on SQL privileges, see Planning Security.