DEV Community

Discussion on: Row Level Security with an ARRAY of tenants set in session parameter (RLS)

Collapse
 
franckpachot profile image
Franck Pachot

The ways I know to bypass RLS in general are: connect with the owner, or with a user with BYPASSRLS. For a single user with the same user that is used for RLS, you can also create a view on the table and grant it for select. Then reading from the view will not apply the RLS.