[postgis-users] AddGeometryColumn with any user

Gustavo Henrique Sberze Ribas gribas at cpqd.com.br
Fri Aug 26 04:33:54 PDT 2005


  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'



> 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

More information about the postgis-users mailing list