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? ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match