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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Mel Jamero <mel(at)gmanmi(dot)tv>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: psql DBNAME -U USER (how to disable -U option?)
Date: 2003-06-17 14:13:46
Message-ID: Pine.LNX.4.33.0306170813190.2018-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Spiegelberg 2003-06-17 14:33:48 Vacuum & Memory Exhausted error
Previous Message Mel Jamero 2003-06-17 13:56:40 psql DBNAME -U USER (how to disable -U option?)