Row-Level Security

ALTER TABLE ... NO FORCE ROW LEVEL SECURITY

Lock mode ACCESS EXCLUSIVE
Risk HIGH
Blocks reads, writes, other DDL
pgfence rule no-force-rls
ALTER TABLE orders NO FORCE ROW LEVEL SECURITY;

What this does

Lets the table owner bypass RLS policies again. Verify owner-backed application connections are not relying on policy enforcement before removing it.

Safe rewrite

Confirm owner bypass is intentional before removing forced RLS

ALTER TABLE orders NO FORCE ROW LEVEL SECURITY;

Read more

More in Row-Level Security