Re: [GENERAL] Privileges on information_schema

2007-10-05 Thread Tom Lane
"Christian Rengstl" <[EMAIL PROTECTED]> writes: > whenever I execute the following query as admin I get all results, but > as soon as I execute it as a less-privileged user the result is empty. > SELECT * FROM information_schema.schemata The SQL standard specifies that information_schema.schemata

[GENERAL] Privileges on information_schema

2007-10-05 Thread Christian Rengstl
Hi list, whenever I execute the following query as admin I get all results, but as soon as I execute it as a less-privileged user the result is empty. SELECT * FROM information_schema.schemata Strange enough, when I query information_schema.tables I can see everything both as a normal user and ad