Lack of information on materialized views in information_schema.table_privileges.

Hi,
after:

create schema test_schema;
create materialized view test_schema.test_mat_view as select 1;
grant select on test_schema.test_mat_view to public;

information_schema.table_privileges does not show privileges on the view:

select grantee, string_agg(privilege_type, ', ') as privileges
from information_schema.table_privileges
where table_schema = 'test_schema' and table_name = 'test_mat_view'
group by grantee;

grantee | privileges
---------+------------
(0 rows)

Should be:

grantee | privileges
----------+---------------------------------------------------------------
postgres | INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER
PUBLIC | SELECT
(2 rows)

Of course, privileges are properly defined in pg_class:

select relname, relnamespace::regnamespace, relacl
from pg_class
where relnamespace = 'test_schema'::regnamespace and relname =
'test_mat_view';

relname | relnamespace | relacl
---------------+--------------+-----------------------------------------
test_mat_view | test_schema | {postgres=arwdDxt/postgres,=r/postgres}
(1 rows)

Related post on stackoverflow.com:
https://stackoverflow.com/questions/38728548/list-grants-and-privileges-for-a-materialized-view-in-postgresql

------
Jan Przemysław Wójcik

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html