How to display spatial data stored in another schema?
Prior to version 10.1.2, the only way to view spatial data stored in a user B’s schema from user A is by granting select permission on B’s tables to A, then create views in schema A, and populate its user_sdo_geom_metadata with metadata for those views. You can then create themes for these views and display them from MapViewer. Starting with version 10.1.2, you have two more options. One is to define public synonyms for tables in schema B, and then populate A’s user_sdo_geom_metadata view for those synonyms, similar to the above view-based approach. Another option is to simply create themes in schema B, define a new data source for schema B. Then you can import B’s themes in any MapRequest as long as you specify the proper data source name for them. In fact this approach lets you integrate spatial data from as many schemas as you want.
