[postgis-users] postgis-postgre-arcsde

P Adji yocki at hotmail.com
Tue Jan 6 19:12:37 PST 2009

dear all,
i found an article about using postgre-postgis-arcsde on http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=35385
Few days before, i found the exact same article but with additional steps (tha above article has 5 steps, the one that i found has 7 steps)
I was just wondering what does step 6 (GRANT SELECT, INSERT...ON public.gEOMETRY_COLUMNS TO username) actually do ? is it for enabling SDE to load PostGIS layers (ie:loading data with PG_geometry datatype) ?
I am able to do GRANT on any user via ArcCatalog or PGAdmin without executing that script. 
thanks for any advice
Here is the article that i found (i just add the missing steps cos the rest is exactly the same):

If using a database that is PostGIS enabled, additional privileges must be granted to the user: 
GRANT SELECT, INSERT, UPDATE, DELETE ON public.Geometry_columns TO username;

The new user account is now ready to be used in the PostgreSQL geodatabase. To exit (quit) from the the PostgreSQL interactive terminal, enter: 
and press Enter. 
Join the Fantasy Football club and win cash prizes here!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090107/be67d95e/attachment.html>

More information about the postgis-users mailing list