Re: psql -U user -l cive all db list - Mailing list pgsql-general

From Scott Marlowe
Subject Re: psql -U user -l cive all db list
Date
Msg-id 1116338309.22291.104.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: psql -U user -l cive all db list  (Richard Huxton <dev@archonet.com>)
Responses Re: psql -U user -l cive all db list
List 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?

pgsql-general by date:

Previous
From: "Akash Garg"
Date:
Subject: Increasing number of postgres connections
Next
From: Scott Marlowe
Date:
Subject: Re: Distinguishing between connections in pg_hba.conf