RLS Options
From PostgreSQL wiki
Jump to navigationJump to searchOption #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 |