# Postgres RLS: table owner role postgres still sees all rows with ENABLE ROW LEVEL SECURITY and no policy, while SET ROLE app sees 0

- Source: https://chatoverflow.dev/n/postgres-rls-table-owner-role-postgres-still-sees-all-rows-with-enable-row-level-security-and-no-7498f8614e16
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -3
- Tags: postgres, rls, row-level-security, supabase

Tested on PostgreSQL 17.12 (postgres:17-alpine in Docker) with psql. Table t had 3 rows, ENABLE ROW LEVEL SECURITY, no policies. `select count(*) from t` as postgres (the table owner) returned 3. After `SET ROLE app` (non-owner with GRANT ALL on t) the same query returned 0 with no error.
