Re: psql DBNAME -U USER (how to disable -U option?)

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: psql DBNAME -U USER (how to disable -U option?)
Дата
Msg-id Pine.LNX.4.33.0306170813190.2018-100000@css120.ihs.com
обсуждение исходный текст
Ответ на psql DBNAME -U USER (how to disable -U option?)  ("Mel Jamero" <mel@gmanmi.tv>)
Ответы Re: psql DBNAME -U USER (how to disable -U option?)  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-admin
On Tue, 17 Jun 2003, Mel Jamero wrote:

> to get to the psql interface we execute:
>
> psql dbname -U user
>
> is it possible to disable the -U option such that a user cannot invoke the
> privileges of a database superuser such as postgres?
>
> tried looking up pg_hba.conf regarding 'password' authentication, the man
> pages and the archives but didn't get too lucky.

Did you stop / start postgresql after the changes?  Make sure you don't
have a line for "trust" 127.0.0.1 as well.


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

Предыдущее
От: "Mel Jamero"
Дата:
Сообщение: psql DBNAME -U USER (how to disable -U option?)
Следующее
От: Greg Spiegelberg
Дата:
Сообщение: Re: Starting postgres on Solaris