On Tue, 2005-05-17 at 09:18, Tino Wildenhain wrote: > 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 :-) All for a feature of questionable value. Better to worry about the real security than worry about such things I think. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly