[Solved] Given the following policy on table documents: CREATE POLICY user_policy ON documents FOR SELECT USING (owner = current_user); What rows will a user see when they run SELECT * FROM documents;? | PostgreSQL

PostgreSQL - Roles and Security

Given the following policy on table documents:

CREATE POLICY user_policy ON documents
FOR SELECT USING (owner = current_user);

What rows will a user see when they run SELECT * FROM documents;?

AOnly rows where the owner column matches the current user

BNo rows, because no policy allows access

CAll rows in the documents table

DOnly rows where owner is NULL

Step-by-Step Solution

Solution:

Step 1: Understand the policy condition
The policy allows SELECT only if owner = current_user, so only rows owned by the current user are visible.
Step 2: Determine visible rows
Rows where the owner matches the current user will be returned; others are filtered out.
Final Answer:
Only rows where the owner column matches the current user -> Option A
Quick Check:
Policy filters rows by owner = current_user [OK]

Quick Trick: Policy USING clause filters rows visible to current_user [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the following policy on table documents: