Re: schema default privilege owner not showing

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>
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
>