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