[postgis-users] Solved? - Connect CAD and ArcGIS to PostGIS / security question

[Stephen V. Mather]

For one, you probably need access to the sequences for the table for your primary keys.

Best,
Steve

  Stephen V. Mather
GIS Manager
(216) 635-3243 (Work)
clevelandmetroparks.com


________________________________________
From: postgis-users-bounces at lists.osgeo.org [postgis-users-bounces at lists.osgeo.org] on behalf of Mark Volz [MarkVolz at co.lyon.mn.us]
Sent: Tuesday, January 22, 2013 10:13 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Solved? - Connect CAD and ArcGIS to PostGIS /  security question

Hello,

I was able to get AutoCAD and ArcGIS to connect to PostGIS by running the following SQL:

GRANT ALL ON SCHEMA public TO caduser;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO caduser;

Questions:

1) Is there any security issues with these SQL statements?
2) I thought I had previously given the CAD users select permissions on the "shapefile" tables, and the spatial reference system tables.  I am trying to figure out what permissions that the sql code did that I had not done via the permissions tab in the table and schema property tab(s).
3) Are References and Trigger privileges needed?  - I am not exactly sure what they do.


I should also mention for anyone interested that I changed the Default Privileges for the public schema so that any new tables added to the database will have select permissions.


Mark Volz
GIS Specialist
Lyon County, MN
(507) 532-8218


_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users