Hi,
after:create schema test_schema;create materialized view test_schema.test_mat_view as select 1;grant select on
test_schema.test_mat_viewto public;
information_schema.table_privileges does not show privileges on the view:select grantee, string_agg(privilege_type, ',
')as privilegesfrom information_schema.table_privilegeswhere table_schema = 'test_schema' and table_name =
'test_mat_view'groupby 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, relaclfrom
pg_classwhererelnamespace = 'test_schema'::regnamespace and relname =
'test_mat_view';
relname | relnamespace | relacl
---------------+--------------+-----------------------------------------test_mat_view | test_schema |
{postgres=arwdDxt/postgres,=r/postgres}(1rows)
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