[postgis-users] postgis-postgre-arcsde

[Obe, Regina]

P Adj,

The  GRANT SELECT, INSERT, UPDATE, DELETE ON public.Geometry_columns TO
username;
 
simply gives the designated user rights to read, add, delete, update the
geometry_columns table which is the table that holds meta data about
each geometry column in the database.

http://postgis.refractions.net/documentation/manual-svn/ch04.html#id2585
859
 
You always want SELECT  rights for all users who will be reading data,
but you really don't need the 
 
INSERT, UPDATE, DELETE 
 
except for the users that will be creating new spatial tables, adding
geometry columns to existing tables and dropping geometry columns.
 
If you can GRANT on any user, then your GUI is probably doing the same
as what the above SQL script does.  

I actually haven't played with ArcCatalog/ArcMap much (have that still
on my todo).  The closest I got to that was helping a fellow coworker
resolve a very obscure MDAC corruption that prevented him from
connecting to City's SQL Server SDE via ArcMap and ArcCatalog and was
giving cryptic messages in ArcMap that none of the ArcMap experts around
here could figure out - (admittedly had really nothing to do with
ArcMap) - go figure.
 
Hope that helps,
Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of P
Adji
Sent: Tuesday, January 06, 2009 10:13 PM
To: surya
Subject: [postgis-users] postgis-postgre-arcsde


dear all,
 
i found an article about using postgre-postgis-arcsde on
http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleS
how&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):
 


6.	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;

 

7.	The new user account is now ready to be used in the PostgreSQL
geodatabase. 
	
	To exit (quit) from the the PostgreSQL interactive terminal,
enter: 

\q



and press Enter. 


 
============================================================

 


________________________________

Chat online and in real-time with friends and family! Windows Live
Messenger <http://get.live.com/messenger/overview>  
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.