Postgres Pro
Downloads
Home   >   mailing lists

Re: psql DBNAME -U USER (how to disable -U option?) - Mailing list pgsql-admin

From scott.marlowe
Subject Re: psql DBNAME -U USER (how to disable -U option?)
Date
Msg-id Pine.LNX.4.33.0306170813190.2018-100000@css120.ihs.com
Whole thread Raw
In response to psql DBNAME -U USER (how to disable -U option?)  ("Mel Jamero" <mel@gmanmi.tv>)
Responses Re: psql DBNAME -U USER (how to disable -U option?)  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: "Mel Jamero"
Date:
Subject: psql DBNAME -U USER (how to disable -U option?)
Next
From: Greg Spiegelberg
Date:
Subject: Re: Starting postgres on Solaris