RE: schema default privilege owner not showing

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 <andrew(dot)terry(at)centremaps(dot)co(dot)uk<mailto:andrew(dot)terry(at)centremaps(dot)co(dot)uk>> wrote:
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 SELECT ON TABLES TO grp_read;

When viewing the pgadmin “SQL” tab for the “schemaname" schema, all of these just show as:

ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;
ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;
ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;

As such, it’s not possible to tell the difference and which role these are assigned to.

\ddp schemaname in psql seems to show “Owner” for Default access priveleges – I don’t know whether this could be read into the SQL tab?

For reference – i’m setting by user but was also hoping to set just by a group (grp_read) role but that doesn’t seem to be possible

Thanks in advance

Andy