Hi, What I've been trying to do: write a web app that, upon receiving a request, automatically gets a DB connection with only the permissions it needs. In order to do that I'd like to create a mechanism for dynamically granting a role a set of permissions necessary for the given request and then re
Hi, What I've been trying to do: write a web app that, upon receiving a request, automatically gets a DB connection with only the permissions it needs. There are a number of solutions to this problem: you could use triggers/view, you could use security definer functions to grant/revoke permissions
