RE: schema default privilege owner not showing

2020-09-14 Thread Andrew Terry
Hi, Thanks – good to know it’s valid and will hopefully get updated in the future. Cheers Andy === Hi, This issue has already been logged. Ref: https://redmine.postgresql.org/issues/4256 Thanks, Khushboo On Fri, Sep 11, 2020 at 5:45 PM Andrew Terry mailto:andrew.te

schema default privilege owner not showing

2020-09-11 Thread Andrew Terry
Hi, Trying out assigning privileges such as: ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read; ALTER DEFAULT PRIVILEGES FOR ROLE usr_1 IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read; ALTER DEFAULT PRIVILEGES FOR ROLE usr_2 IN SCHEMA schemaname GRANT SELE

schema privileges not showing

2020-09-11 Thread Andrew Terry
Hi, Trying out assigning privileges such as: ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read; ALTER DEFAULT PRIVILEGES FOR ROLE usr_1 IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read; ALTER DEFAULT PRIVILEGES FOR ROLE usr_2 IN SCHEMA schemaname GRANT SELE