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

Поиск
Список
Период
Сортировка
От Jonathan Katz
Тема Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
Дата
Msg-id A0E82030-D418-4596-A6E5-87016B0CCCE7@excoventures.com
обсуждение исходный текст
Ответ на Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links  (aditya desai <admad123@gmail.com>)
Ответы Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Дерево обсуждения


On Dec 17, 2021, at 10:43 AM, aditya desai <admad123@gmail.com> wrote:

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?

dblink lets you pass in a PostgreSQL connection string[1].
From there you can reference parameters to use certificates[2].

Jonathan

В списке pgsql-sql по дате отправления:

Предыдущее
От: aditya desai
Дата:
Сообщение: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links