RLS Options

From PostgreSQL wiki
Jump to navigationJump to search

Option #1:

row_security BypassRLS ForceRLS Owner Result
on true true true Apply
on true true false Apply
on true false true Don't Apply
on true false false Apply
on false true true Apply
on false true false Apply
on false false true Don't Apply
on false false false Apply
row_security BypassRLS ForceRLS Owner Result
off true true true Don't Apply
off true true false Don't Apply
off true false true Don't Apply
off true false false Don't Apply
off false true true Don't Apply
off false true false Error
off false false true Don't Apply
off false false false Error

Option #2:

row_security BypassRLS ForceRLS Owner Result
on true true true Don't Apply
on true true false Don't Apply
on true false true Don't Apply
on true false false Don't Apply
on false true true Apply
on false true false Apply
on false false true Don't Apply
on false false false Apply
row_security BypassRLS ForceRLS Owner Result
off true true true Don't Apply
off true true false Don't Apply
off true false true Don't Apply
off true false false Don't Apply
off false true true Don't Apply
off false true false Error
off false false true Don't Apply
off false false false Error