Advanced
Database Management Systems
Q94 / 100
What is the difference between row-level security and view-based security?
Correct! Well done.
Incorrect.
The correct answer is B) Row-level security (RLS) enforces access control policies at the database engine level per row; views restrict visible rows but can be bypassed if users have direct table access
B
Correct Answer
Row-level security (RLS) enforces access control policies at the database engine level per row; views restrict visible rows but can be bypassed if users have direct table access
Explanation
PostgreSQL RLS: CREATE POLICY defines row-visibility predicates applied automatically to all queries on the table. Users cannot bypass RLS even with direct table access. Views require denying direct table access separately.
Progress
94/100