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...
#Security
Protecting data and controlling access.
3 notes tagged
SQL
SQL Injection and Parameterised Queries
Why string concatenation lets user input rewrite your query, and why prepared statements make it structurally impossible - with the cases parameters c...
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...