Type a security view that exposes only the honours subset:
Type a security view that exposes only the honours subset:
Answer
CREATE VIEW honors_student AS SELECT student_id, name, gpa FROM students WHERE gpa >= 3.5;
Granting access to honors_student instead of students restricts users to rows with gpa >= 3.5 and only the listed columns — the view is the security boundary.