~/ 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/a0ac3490-1cb0-496f-9e0c-9bdb00816088/flashcard utf-8 LF