Thread: Adding Default Privileges to a schema for a role
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 haveread permissions to any tables created in the future. In pgAdmin III I opened up the Default privileges for the publicschema and I only see the Public role in the Role/ Group dropdown. Is there any reason why I can see other groupsin 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 DefaultPrivileges tab. I don't remember doing anything special to see other groups on the older machine. This isn't a bugis it? Thank You Mark Volz GIS Specialist
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