[Solved] You want to allow users to SELECT rows from tasks table only if they are assigned to the task or if they are an admin.... Which policy condition correctly enforces this? | PostgreSQL

PostgreSQL - Roles and Security

You want to allow users to SELECT rows from tasks table only if they are assigned to the task or if they are an admin. The tasks table has columns assigned_user and is_admin (boolean). Which policy condition correctly enforces this?

AUSING (assigned_user = current_user)

BUSING (assigned_user = current_user AND is_admin = true)

CUSING (is_admin = true)

DUSING (assigned_user = current_user OR is_admin = true)

Step-by-Step Solution

Solution:

Step 1: Understand access requirements
Users can access rows if assigned_user matches or if they are admin.
Step 2: Translate to condition
Condition must allow either assigned_user = current_user OR is_admin = true.
Final Answer:
USING (assigned_user = current_user OR is_admin = true) -> Option D
Quick Check:
Use OR to allow either condition = USING (assigned_user = current_user OR is_admin = true) [OK]

Quick Trick: Use OR to combine multiple access conditions in policy. [OK]

Common Mistakes:

Using AND instead of OR
Allowing only assigned_user without admin check
Allowing only admin without assigned_user

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Which policy condition correctly enforces this?

Step 1: Understand access requirements

Step 2: Translate to condition

Final Answer:

Quick Check:

Want More Practice?