Re: Problems with user-level security

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with user-level security
Дата
Msg-id 5539.1005157268@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problems with user-level security  (Nick Sayer <nsayer@quack.kfu.com>)
Список pgsql-admin
Nick Sayer <nsayer@quack.kfu.com> writes:
> Is there some way to achieve this I am missing?

For password-style authentication, you can use a secondary auth file to
get that effect:

local sameuser password
local all password crossauth

where $PGDATA/crossauth lists the users who should be allowed to connect
to databases other than their own:

backups
pgsql

The map file can serve a similar purpose for ident-based auth.  AFAIK
there's no similar capability for Kerberos or PAM auth methods :-(

            regards, tom lane

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Problems with user-level security
Следующее
От: "Shuzo Kubo"
Дата:
Сообщение: REINDEXing user table in non stand-alone?