Re: table_privileges view under information_schema doesn't showprivileges on materialized views - Mailing list pgsql-hackers

From Ashutosh Sharma
Subject Re: table_privileges view under information_schema doesn't showprivileges on materialized views
Date
Msg-id CAE9k0P=XOgidMiFpUEvqNaJdA5g3GR1C6iM-T5D_uG+oeVHJtg@mail.gmail.com
Whole thread Raw
In response to Re: table_privileges view under information_schema doesn't show privileges on materialized views  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Aug 24, 2018 at 9:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Ashutosh Sharma <ashu.coek88@gmail.com> writes:
>> Currently, table_privileges view in information_schema.sql doesn't
>> show privileges on materialized views for currently enabled roles. As
>> per the documentation-[1], it should be showing the all privileges
>> granted on tables and views (the documentation doesn't says it has to
>> be normal view). Shouldn't we allow it to show privileges on
>> materialized views as well.
>
> The spec is quite clear that rows in table_privileges must correspond
> to rows in information_schema.tables, but we don't show materialized
> views there.
>

Okay, In that case, I've changed the patch so that both tables and
tables_privileges shows the materialized view. PFA patch. Sorry, I
just missed that point earlier.

> Perhaps there's a case for showing MVs in the "tables" view, and thence
> also in table_privileges, but this patch by itself is flat wrong.
>
> Anyway it seems to me we made that decision already; it's a bit late now
> to be revisiting whether MVs should be treated as tables here.
>
>                         regards, tom lane

Attachment

pgsql-hackers by date:

Previous
From: Michael Banck
Date:
Subject: pg_verify_checksums -d option (was: Re: pg_verify_checksums -roption)
Next
From: Yugo Nagata
Date:
Subject: Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -roption)