SQL
Users, Roles, GRANT, REVOKE and Least Privilege
Controlling who can do what: creating users, granting the minimum needed, grouping privileges into roles, and the accounts a typical application actua...
#Views
Stored queries used as virtual tables.
4 notes tagged
SQL
Temporary Tables vs CTEs vs Views vs Derived Tables
Four ways to name an intermediate result, and a decision rule for choosing between them based on scope, reuse and whether you need an index.
SQL
Updatable Views, Dropping Views and Views vs Tables
When you can INSERT or UPDATE through a view, what WITH CHECK OPTION protects against, and an honest comparison of views, tables and materialised view...
SQL
Creating and Querying Views
A view is a stored query you can select from like a table. Learn CREATE VIEW, how views are executed, and the four jobs they do well.