Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links

Hi,
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?



Regards,
Aditya.