Spatial Query Return Bad Result For A User And Good Result For Other.
Last updated on OCTOBER 31, 2016
Applies to:Oracle Spatial and Graph - Version 188.8.131.52 and later
Information in this document applies to any platform.
When running a spatial queries on views using another user and not the owner, the result is different (incorrect) from using the owner.
View FBI_IGT_ZCBV_VUE in one schema (FBI) with MDSYS.SDO_GEOMETRY column, this view use a view IGT_ZCB_FBI_VUE in other schema (IGT)
For this query:
SELECT * FROM FBI_IGT_ZCBV_VUE
WHERE sdo_anyinteract (ZCB_GEOMETRIE, SDO_GEOMETRY(2001, 8265, SDO_POINT_TYPE(-69.90, 49.84, NULL), NULL, NULL)) = 'TRUE';
With only GRANT SELECT ON IGT_ZCB_FBI_VUE TO FBI with grant option :
If FBI query FBI_IGT_ZCBV_VUE no row is returned --> BAD RESULT
If IGT user query igt.IGT_ZCB_FBI_VUE or fbi.FBI_IGT_ZCBV_VUE the result is good (same).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms