[postgis-users] postgis for arcgis / default permission problems

[Mark Volz]

Hello,

I am having some issues with the default privileges in postgres / postgis.  If anyone could take a look at what I am doing wrong, or better yet if anyone has a how to document for setting up postgis / postgres for ArcGIS users let me know.  


I am reinstalling postgres / postgis on a machine that will eventually be used for serving data to ArcGIS, Mapserver, and possibly CAD clients.  Currently there are two users, the first is the postgres "superuser" account.  The other user is just a generic user account which the clients will use for read only access.  I would like to set up default permissions so that the "user" account can access any data that is loaded into the database.  In the past I was able to view users in the privilages and default privileges tab by selecting the option: "Show users for privileges."  When I installed postgres this time I noticed that I could only see users in the privileges dialog and not the default privileges dialog.  

After having issues with not seeing the users in the default privileges dialog box, I decided it might be cleaner to create groups, add users to the groups, and assign privileges to the groups (instead of the users).  The groups did display in the privileges dialog box, however, I did not see any groups in the default privileges dialog box -which was one of the reasons why I decided to use groups in the first place.

I was able to get assign default privileges to the database by running a SQL script.  However, to me it seems like that was for the most part a hack job.

Questions:

1)  If anyone has a how to document for setting up postgres/ postgis for ArcGIS users let me know
2)  Is there a reason why I cannot see any users or groups in the default privileges dialog box?
2)  I was able to alter the default privileges for a database by manually running sql code.  What would I need to do to remove the default privileges of a user or group ?

ALTER DEFAULT PRIVILEGES 
    GRANT SELECT ON TABLES
    TO "GISUsers";

p.s.  I am currently using postgres 9.2.4 with postgis 2.0.3 on a windows box.  In the past I used postgres 9.1.x.


Thank you for any assistance


Mark Volz, GISP
GIS Specialist