[postgis-users] setting SRID

[Zamil Murji]

Thanks! This fixed my problem.
** Note that I had to run this grant statement from the postgres user.

Zamil

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
Gregory S. Williamson
Sent: Friday, April 30, 2004 2:10 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] setting SRID


Try something along the lines of 
  GRANT SELECT,INSERT,UPDATE,DELETE ON geometry_columns TO idcdev;
(using the psql tool, pgAdmin, etc.)

(or "TO GROUP grpname" if a group is used to control access).

This will allow the user "idcdev" to select, insert and delete data in that table, as well as update it. You probably can restrict this is SELECT,INSERT if this user is not expected to need to change entries once made, or delete them.

HTH

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: Zamil Murji [mailto:Zamil.Murji at divestco.com]
Sent: Friday, April 30, 2004 12:53 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] setting SRID


Hello list,

I've been using PostGIS for a little while now and everything is working great. I created a new db and ran both the sql scripts that came with PostGIS. 

A simple \d returns the following:
              List of relations
 Schema |       Name       | Type  |  Owner
--------+------------------+-------+----------
 public | geometry_columns | table | postgres
 public | main_well1       | table | idcdev
 public | spatial_ref_sys  | table | postgres
 public | well             | table | idcdev
 public | well_log_job     | table | idcdev
 public | well_log_raster  | table | idcdev
(6 rows)

Everything looks great, except when I goto to run the following statement:
SELECT AddGeometryColumn('idcdev', 'main_well1', 'the_geom', -1, 'POINT', 2);

I get the following error:
WARNING:  Error occurred while executing PL/pgSQL function addgeometrycolumn
WARNING:  line 39 at execute statement
ERROR:  geometry_columns: permission denied

How can I solve this? Is there some permissions that I have to grant to the user idcdev? If so, which ones and how do I grant them?

Thanks
Zamil
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users