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

From Mark Volz
Subject Adding Default Privileges to a schema for a role
Date
Msg-id 36CA828A36E29F45B7CF0A1766E5DFA3188197@swmail01.r8nssis.local
Whole thread Raw
Responses Re: Adding Default Privileges to a schema for a role
List 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
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



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Copy rows, remember old and new pkey
Next
From: gautammaji
Date:
Subject: Re: Regarding the shared disk fail over cluster configuration