Re: Adding Default Privileges to a schema for a role - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Adding Default Privileges to a schema for a role
Date
Msg-id 1354006449.2129.11.camel@localhost.localdomain
Whole thread Raw
In response to Adding Default Privileges to a schema for a role  (Mark Volz <MarkVolz@co.lyon.mn.us>)
List 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
automaticallyhave read permissions to any tables created in the future.  In pgAdmin III I opened up the Default
privilegesfor the public schema and I only see the Public role in the Role/ Group dropdown.  Is there any reason why I
cansee 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



pgsql-general by date:

Previous
From: wd
Date:
Subject: Re: Restore postgres to specific time
Next
From: classical_89
Date:
Subject: Re: Correlation in pg_stats