[Solved] Given the table orders with RLS enabled and this policy:CREATE POLICY order_owner ON orders FOR SELECT USING (owner = current_user);What will the query SELECT *... return when run by user alice? | PostgreSQL

PostgreSQL - Roles and Security

Given the table orders with RLS enabled and this policy:

CREATE POLICY order_owner ON orders FOR SELECT USING (owner = current_user);

What will the query SELECT * FROM orders; return when run by user alice?

ANo rows, because no policy allows access.

BAll rows in the orders table.

COnly rows where the owner column equals 'alice'.

DAn error because the policy is incomplete.

Step-by-Step Solution

Solution:

Step 1: Understand the policy effect
The policy allows SELECT only on rows where owner = current_user.
Step 2: Apply policy for user 'alice'
When alice runs the query, only rows with owner = 'alice' are visible.
Final Answer:
Only rows where the owner column equals 'alice'. -> Option C
Quick Check:
RLS filters rows by owner = current_user = Only rows where the owner column equals 'alice'. [OK]

Quick Trick: RLS filters rows based on policy condition for current user. [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table orders with RLS enabled and this policy: