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.te...@centremaps.co.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 >
