| From: | Mark Volz <MarkVolz(at)co(dot)lyon(dot)mn(dot)us> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Adding Default Privileges to a schema for a role |
| Date: | 2012-11-26 18:56:17 |
| Message-ID: | 36CA828A36E29F45B7CF0A1766E5DFA3188197@swmail01.r8nssis.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I created a role called Workers. I am able edit the privileges for the Workers role in the public schema of a database. I also would like to edit the default privileges of the schema as well so that the Workers group will automatically have read permissions to any tables created in the future. In pgAdmin III I opened up the Default privileges for the public schema and I only see the Public role in the Role/ Group dropdown. Is there any reason why I can see other groups in the Privileges tab, but not the Default Privileges tab?
P.S. I did notice on an older (9.0?) 32 bit version of PostGIS I am able to see more than just the public role in the Default Privileges tab. I don't remember doing anything special to see other groups on the older machine. This isn't a bug is it?
Thank You
Mark Volz
GIS Specialist
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Kroon | 2012-11-26 19:51:02 | Re: Prevent x005F from xml |
| Previous Message | Merlin Moncure | 2012-11-26 18:15:00 | Re: Copy rows, remember old and new pkey |