CS 330
Lecture 10

Finish Embedded SQL.
Dynamic SQL, Ch. 9.8 textbook.
Start Ch. 10: Security, Views and SQL
- Security issues: secrecy, integrity, availability.
- Views
  - Destroying/Altering tables and views
  - Queries on views
  - Updates on views
- Access Control
- Discretionary access control. GRANT and REVOKE in SQL. Examples.