Hi,
The mdsys.all_sdo_geom_metadata is a special view of the mdsys schema that is visible only to a user with special rights (dba for ex.).
If the user connect is not administrator , it would use the
mdsys.user_sdo_geom_metadata.
that is a view filtered on the actual user connected. To see only the records about the tables owned by the user.
regards,
Andrea Peri.
geoserver-users-request@lists.sourceforge.net ha scritto:
...
01 Apr 13:50:42 DEBUG [data.oracle] - the sql statement for srid is SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME='FFH_SDO' AND COLUMN_NAME='SHAPE'
...
But the schema MDSYS doesn't contain a table ALL_SDO_GEOM_METADATA. So the sql request doesnt work. therefore the next entry is:
Wait, how is this possible? That table is a standard one and everybody
should be able to see it?
Moreover:
...
andrea.peri@anonymised.com ha scritto:
Hi,
The mdsys.all_sdo_geom_metadata is a special view of the mdsys schema that is visible only to a user with special rights (dba for ex.).
If the user connect is not administrator , it would use the
mdsys.user_sdo_geom_metadata.
that is a view filtered on the actual user connected. To see only the records about the tables owned by the user.
Sigh. The OracleDataStore once used to access user_sdo_geom_metadata
and many users complained because they were using users without
schema access credentials and thus the user_sdo_geom_metadata
table was not visible to them, and asked the
ALL_SDO_GEOM_METADATA to be used instead:
http://jira.codehaus.org/browse/GEOT-1441
http://jira.codehaus.org/browse/GEOT-319
http://jira.codehaus.org/browse/GEOS-1592
http://jira.codehaus.org/browse/GEOS-1302
I only fire up Oracle to fix some random bug, but given that
there is no real Oracle maintainer I trusted the various
users and switched the query to use all_sdo_geom_metadata.
Cheers
Andrea