Search Postgresql Archives

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

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

 



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

---------------------------(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

[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