~/ learn/ comp-378/ cards/ Views (Dynamic vs. Materialized) & WITH CHECK OPTION
1 of 5

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.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/abda8878-319c-49ac-9288-bd0c0e5af11d/flashcard utf-8 LF