I currently manage a SDE Geodatabase for a regional government agency and would like to restrict access to certain geographic areas with a layer. Example Water Main layer in SDE. Is there anyway to do this in SDE? We are on ArcGIS 9.3 using an Oracle DBMS.
There is no way for ArcSDE to restrict a spatial query. Some *applications* (like ArcGIS Server) can limit the window from which you are permitted to query, but that's not done at the SQL level. - V
If your layer is non-versioned, what if you created two spatial views of the layer based on a where clause for certain records, one for everyone and one for restricted access and then assign permissions to the views? Would that work?
