<div>Hi,</div><div> </div><div>What I've been trying to do: write a web app that, upon receiving a request, automatically gets a DB connection with <strong>only </strong>the permissions it needs.</div><div> </div><div>There are a number of solutions to this problem: you could use triggers/view, you could use security definer functions to grant/revoke permissions for a pool of roles. None of the solutions I've been able to come up with work on connections to the standby.</div><div> </div><div>Does anything I've stated above strike you as obviously wrong? If not, do you perhaps have any ideas on how this problem could be tackled?</div><div> </div><div>I would very much appreciate any ideas.</div><div> </div><div>Cheers,</div><div>Vladimir</div>