Search Postgresql Archives

Re: PG vs MySQL

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

 



On Sun, 28 Mar 2004, Mike Nolan wrote:

> The \l command should only list databases that the current user is
> authorized for, the \du command should only list users authorized for
> the current database (and perhaps only superusers should get even that
> much information), etc.  Perhaps it is possible to set PG to do this,
> but that should probably be the default.

Just curious ... restricting \l itself isn't too difficult ... but how
does MySQL restrict the ability to do something like:

SELECT datname FROM pg_database;

or does it not have an equivalent to that?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

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