[tellak]

Note that you don’t have to use the connection credentials to make use of row level security in pg. the security policy can be based on session variables (or anything really) which can be changed during the connection.

Edit: it’s not the same thing but fwiw pg row level security is completely decoupled from the dbms access control.