Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux