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

From Richard Huxton
Subject Re: psql -U user -l cive all db list
Date
Msg-id 4289BEC5.20405@archonet.com
Whole thread Raw
In response to psql -U user -l cive all db list  (Margus Roo <margusja@kodila.ee>)
Responses Re: psql -U user -l cive all db list
List pgsql-general
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.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Margus Roo
Date:
Subject: psql -U user -l cive all db list
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: Distinguishing between connections in pg_hba.conf