Security Lab: (a) In MySQL, create two users: 'admin_user' (full privileges) and 'readonly_user' (SELECT only). Create a VIEW called STUDENT_PUBLIC that hides student BVN and health records. Grant the readonly_user access to the view only. Verify that readonly_user cannot access the base STUDENT table. (b) Identify a vulnerable SQL query in a sample application code provided by the lecturer. Rewrite it using parameterised queries.

Assignment

Continue working on Assignment 3 (Due Week 9). Ensure your SQL queries demonstrate awareness of security considerations (use of views, appropriate access controls). Begin reviewing concurrency and recovery concepts for the final weeks.