Is there any way to achieve autonomous transactions in Postgres? There is a way to do it by using DB Link. However DB Link involves user name and password which is a bit of a security threat.
How to use certificate based authentication in DB Links instead of hardcoding user name and password in it?