Re: BUG #1937: Parts of information_schema only accessible to owner

Tony Marston wrote:
> I have searched through the SQL 2003 standard and can find no such
> restriction. In the volume titled "Information and Definition Schemas
> (SQL/Schemata)" in section 5.20 (INORMATON_SCHEMA.COLUMNS view) it
> states the following under the heading "Function":
>
> "Identify the columns of tables defined in this catalog that are
> accessible to a given user or role."

The information schema currently follows SQL 1999.  Interestingly, the
requirement to "blank out" the column defaults of non-owned tables was
apparently dropped in SQL 2003.  Clearly, we need to review the
information schema for SQL 2003 conformance.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/