About this document
Views and Authorization in Databases by kevinazhu is a document available to read on EtoBox.
Views allow users to see virtual tables computed from real tables. Views can be used like tables in queries and support updates under certain conditions. Materialized views physically store the results of view queries to optimize performance. Authorization controls which users can access and modify tables using privileges granted to users and optionally delegated with grant options. Views also require privileges on underlying tables and may be dropped if those privileges are revoked.
- Author
- kevinazhu
- Language
- EN