Row-Level Security Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Database Authorization

What you'll be asked

  1. What is the primary purpose of Row-Level Security (RLS) in a database?
  2. When a Row-Level Security policy is applied to a table, what happens to a user who executes a 'SELECT *' query but does not meet the policy criteria for any rows?
  3. Which of the following is a common use case for implementing Row-Level Security in a multi-tenant application?
  4. If a table has both a Row-Level Security policy and a standard GRANT/REVOKE permission set, which is evaluated first?
  5. You are troubleshooting an RLS policy that uses a session-based variable (e.g., 'SESSION_CONTEXT' or 'SET ROLE'). If a user connects via a connection pool that reuses sessions, what is the most significant risk?

Answers and explanations come after you submit.