Re: BUG #5457: dblink_connect now restricts non-superusers to password

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: BUG #5457: dblink_connect now restricts non-superusers to password
Дата
Msg-id 201005111259.o4BCx7624935@momjian.us
обсуждение исходный текст
Ответ на BUG #5457: dblink_connect now restricts non-superusers to password  ("Chana Slutzkin" <chana@cs.huji.ac.il>)
Список pgsql-bugs
Chana Slutzkin wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5457
> Logged by:          Chana Slutzkin
> Email address:      chana@cs.huji.ac.il
> PostgreSQL version: 8.4
> Operating system:   FreeBSD 7.2
> Description:        dblink_connect now restricts non-superusers to password
> Details:
>
> dblink in version 8.4 forces a non-superuser to connect using a password.
> I would prefer to use ident.

I don't think ident is a good idea because the connection is coming from
the database server, not the client.  The database server is always
going to be user 'postgres'.  However, I assume pg_hba.conf could allow
you do make this work somehow, but with little security.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: BUG #5457: dblink_connect now restricts non-superusers to password
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5458: Permission check is skipped by inheritance