topic Re: Cross Schema Spatial View in Data Management Questions

Cross Schema Spatial View

AdamZiegler — Tue, 08 Jun 2010 17:55:14 GMT

I am working in an Oracle 10.2.0.4 database with ArcSDE 9.3.1 SP1. I am working on creating a cross schema spatial view, or a view created from tabular data from one schema combined with spatial data from another schema. I have been successful with my view creation, but I had a question about the grant option required. Is the grant option required by Oracle or SDE?

I would have posted my question on this post, http://search.esri.com/results/index.cfm?start=0&q=sde+view+cross+schema, but I guess the old forum is locked down.

Thanks,
Adam Z
County of Chester, PA - SDE Admin

Re: Cross Schema Spatial View

VinceAngelo — Tue, 08 Jun 2010 19:42:28 GMT

GRANT OPTION is a SQL standard thing, required by Oracle. It is necessary when a non-owner
attempts to grant other users access to a table with a view. See the Oracle docs for more info.

- V

Re: Cross Schema Spatial View

AdamZiegler — Wed, 09 Jun 2010 10:42:22 GMT

Thank you Vince.

-Adam Z

Re: Cross Schema Spatial View

RobertHu — Wed, 09 Jun 2010 15:53:33 GMT

Have you checked the -I option of sdetable and sdelayer commands? It takes care of GRANT OPTION.

Re: Cross Schema Spatial View

AdamZiegler — Thu, 10 Jun 2010 13:40:45 GMT

Thanks Robert. Yeah, I have everything working, I was just curious about the with Grant Option being needed. It's an Oracle thing.