schema default privilege owner not showing

From: Andrew Terry <andrew(dot)terry(at)centremaps(dot)co(dot)uk>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: schema default privilege owner not showing
Date: 2020-09-11 12:15:20
Message-ID: AM6PR01MB4946ADB025505A17A2FBC24EA1240@AM6PR01MB4946.eurprd01.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2020-09-14 05:00:02 Re: schema default privilege owner not showing
Previous Message Andrew Terry 2020-09-11 12:11:53 schema privileges not showing