Cross Schema Spatial View

[AdamZiegler]

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

[VinceAngelo]

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

[AdamZiegler]

Thank you Vince.

-Adam Z

[RobertHu]

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

[AdamZiegler]

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