Hello
I want to start using Geoserver with an Oracle datasource. I am connecting with user a. The spatial tables are owned by user b. They all have an entry in the user_sdo_geom_metadata tables, as long as you are connected as user b.
I access them as user a for good reasons of security and have synonyms pointing to the tables in the correct schema. It seems that Geoserver forces you to connect as the owner of the table if it looks in USER_SDO_GEOM_METADATA.
Is there anyway around this ? Why can't geoserver look in all_sdo_geom_metadata ? If it looked there, it would find the table information.
Chris
-----------------------------------------
Email provided by http://www.ntlhome.com/
I want to start using Geoserver with an Oracle datasource. I am
connecting with user a. The spatial tables are owned by user b. They
all have an entry in the user_sdo_geom_metadata tables, as long as
you are connected as user b.
I access them as user a for good reasons of security and have
synonyms pointing to the tables in the correct schema. It seems that
Geoserver forces you to connect as the owner of the table if it looks
in USER_SDO_GEOM_METADATA.
Is there anyway around this ? Why can't geoserver look in
all_sdo_geom_metadata ? If it looked there, it would find the table
information.
Darn, I just uninstalled my beastly oracle installation (it was on my
laptop and just sucking 128 megs of ram whenever I started up), so I
can't easily test this easily. But what you say makes sense - I was
the one to recently get GeoServer working with Oracle, and my knowledge
of oracle is limited to say the least. It sounds like the
ALL_SDO_GEOM_METADATA is a much better choice, and like you have a lot
more experience with this stuff. I'm more than happy to change it, and
can send you an updated jar to test with. You think that I can just
change all references from USER_SDO_GEOM_METADATA to
ALL_SDO_GEOM_METADATA ? The table structure is the same, but it lists
all metadata columns? If a user adds his metadata to
USER_SDO_GEOM_METADATA does it automatically show up in
ALL_SDO_GEOM_METADATA ? If two users have the same tablename could
that potentially confuse things? If you're interested in looking at
the source it's at:
http://svn.geotools.org/geotools/branches/2.0.x/gt/plugin/oraclespatial/
particularly:
http://svn.geotools.org/geotools/branches/2.0.x/gt/plugin/oraclespatial/src/org/geotools/data/oracle/OracleDataStore.java
And if you'd like I can make a new jar with changing that code from USER
to ALL.
best regards,
Chris
Chris
-----------------------------------------
Email provided by http://www.ntlhome.com/
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank
Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/