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