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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Margus Roo <margusja(at)kodila(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql -U user -l cive all db list
Date: 2005-05-17 09:52:05
Message-ID: 4289BEC5.20405@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2005-05-17 10:08:02 Re: Distinguishing between connections in pg_hba.conf
Previous Message Margus Roo 2005-05-17 09:27:28 psql -U user -l cive all db list