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

[Mark Volz]

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