| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Mark Volz <MarkVolz(at)co(dot)lyon(dot)mn(dot)us> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Adding Default Privileges to a schema for a role |
| Date: | 2012-11-27 08:54:09 |
| Message-ID: | 1354006449.2129.11.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2012-11-26 at 18:56 +0000, Mark Volz wrote:
> 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?
>
It is a bug with pgAdmin. We had the same question in the
pgadmin-support list, I didn't reply yet, but I reproduce the bug quite
easily. I'll try to work on that to fix it before the next minor
releases.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gareth Lyons | 2012-11-27 13:38:04 | Streaming Replication error - relation uninitialized and WAL contains references to invalid pages |
| Previous Message | wd | 2012-11-27 03:43:14 | Re: Restore postgres to specific time |