Details
-
Type:
Improvement
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: jdbc-oracle plugin
-
Labels:None
Description
Currently the Oracle NG datastore can not deal correctly with the following situation:
X schema owners, which are all accessible by a read-only Oracle user. Using this read-only user I want to access tables from all schema owners in one store.
So the store needs to keep track of the schema owner associated with the tables when doing queries.
It is not possible to "keep track" of the schema internally, as you may have the same name in multiple schemas. The only was to keep a unique reference is to prefix it with the schema.
From my testing in GeoServer, if there are two Oracle tables with the same name in different schemas, GeoServer only shows one of them.