| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, 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 14:18:51 |
| Message-ID: | 1116339532.2441.29.camel@sabrina.peacock.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am Dienstag, den 17.05.2005, 08:58 -0500 schrieb Scott Marlowe:
> 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?
>
And you can get close to that if you carefully moc around with
the system tables and views and their permissions.
But if you do it wrong - restore is your friend :-)
Regards
Tino
--
Tino Wildenhain <tino(at)wildenhain(dot)de>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-05-17 14:28:39 | Re: psql -U user -l cive all db list |
| Previous Message | Scott Marlowe | 2005-05-17 13:59:43 | Re: Distinguishing between connections in pg_hba.conf |