| From: | Andrew Terry <andrew(dot)terry(at)centremaps(dot)co(dot)uk> |
|---|---|
| To: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | schema privileges not showing |
| Date: | 2020-09-11 12:11:53 |
| Message-ID: | AM6PR01MB494687D4F7EA447730191DD2A1240@AM6PR01MB4946.eurprd01.prod.exchangelabs.com |
| Views: | Whole Thread | Raw Message | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Terry | 2020-09-11 12:15:20 | schema default privilege owner not showing |
| Previous Message | Dave Page | 2020-09-11 10:46:12 | Re: problem with docker image : servers.json file mapping |