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 |