I like the information_schema namespace included in 7.4, but it at the 
moment it's rather unusable to me because most views are restricted to 
showing only objects owned by the current_user. I regularly need ALL 
objects visible, as long as the user has rights on it.


Mon, 07 Apr 2003 13:45:45 +0200
Andreas Pflug <Andreas.Pflug@web.de>
information_schema 7.4
On Mon, 2003-04-07 at 07:45, Andreas Pflug wrote:
> I like the information_schema namespace included in 7.4, but it at the 
> moment it's rather unusable to me because most views are restricted to 
> showing only objects owned by the current_user. I regularly need ALL 
> objects visible, as long as the user has rights on it.

You're welcome to read up on the SQL spec for Information_schema, but
the spec (to me) declares that the current_user must own or be able to
modify the object to see it.

I'll agree it makes the information_schema somewhat less useful.

-- 
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc
07 Apr 2003 13:03:15 -0400
Rod Taylor <rbt@rbt.ca>
Re: information_schema 7.4