[Solved] Which command is used to enable row-level security on a PostgreSQL table named orders? — Ans: ALTER TABLE orders ENABLE ROW LEVEL SECURITY; | PostgreSQL

PostgreSQL - Roles and Security

Which command is used to enable row-level security on a PostgreSQL table named orders?

AALTER TABLE orders SET RLS ENABLED;

BALTER TABLE orders ENABLE ROW LEVEL SECURITY;

CSET ROW LEVEL SECURITY ON orders;

DCREATE POLICY orders ENABLE RLS;

Step-by-Step Solution

Solution:

Step 1: Recall syntax to enable RLS
The correct syntax is ALTER TABLE table_name ENABLE ROW LEVEL SECURITY;.
Step 2: Match options
Only ALTER TABLE orders ENABLE ROW LEVEL SECURITY; matches the correct syntax exactly.
Final Answer:
ALTER TABLE orders ENABLE ROW LEVEL SECURITY; -> Option B
Quick Check:
Enable RLS = ALTER TABLE ... ENABLE ROW LEVEL SECURITY [OK]

Quick Trick: Use ALTER TABLE ... ENABLE ROW LEVEL SECURITY to activate RLS. [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which command is used to enable row-level security on a PostgreSQL table named orders?