BUG #10588: inconsistent permissions for InformationSchema tables..

From: tysonzwicker(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10588: inconsistent permissions for InformationSchema tables..
Date: 2014-06-09 22:35:26
Message-ID: 20140609223526.2583.43153@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10588
Logged by: Tyson Zwicker
Email address: tysonzwicker(at)gmail(dot)com
PostgreSQL version: 9.1.9
Operating system: Win 7 x64
Description:

In InformationSchema the "constraint_column_usage" table is only accessible
via the super user account, despite other tables (I tested table_constraints
and key_column_usage) being accessible to any account that was GRANTed ALL
permissions.

Furthermore, attempting to select from "constraint_column_usage" did not
throw an error of any kind, it just returned 0 rows. Once I did the same
query logged in as "postgres" the query returned rows.

I feel that a> An error should be thrown rather than returning 0 rows and
that b> the access of tables in InformationSchema should be consistent
across ALL of the tables.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-06-09 22:50:39 Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Previous Message Jeff Janes 2014-06-09 21:15:24 Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby