Re: psql -U user -l cive all db list

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Margus Roo <margusja(at)kodila(dot)ee>, pgsql-general(at)postgresql(dot)org
Subject: Re: psql -U user -l cive all db list
Date: 2005-05-17 13:58:30
Message-ID: 1116338309.22291.104.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2005-05-17 at 04:52, Richard Huxton wrote:
> Margus Roo wrote:
> >
> > What I must change that non root user will see only own databases?
>
> You can't at the moment. There has been some discussion about this, but
> at present read access to the system catalogues is available to everyone.
>
> That doesn't mean they can connect to the database (that's controlled by
> your pg_hba.conf file). It does mean you can see what databases are
> available though.

Everyone realizes that even Oracle doesn't provide this functionality,
right?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-05-17 13:59:43 Re: Distinguishing between connections in pg_hba.conf
Previous Message Terry Fielder 2005-05-17 13:33:43 Re: Help - Urgent