[postgis-users] AddGeometryColumn with any user

[Gustavo Henrique Sberze Ribas]

Hi,

  You've got to grant access to the table. Use

  'GRANT ALL ON TABLE public.geometry_columns TO PUBLIC'
  'GRANT ALL ON TABLE public.spatial_ref_sys TO PUBLIC'

  http://www.postgresql.org/docs/current/static/sql-grant.html


--
Gustavo

> hello
> in  my db only postgres user can use "select AddGeometryColumn ..."
> how can I make any user run
> "SELECT AddGeometryColumn('gtest','geom',-1,'POLYGON',2);"
> other than postgres super user.
> regards
> Ahmet Temiz