Spatial Query Returns Incorrect Result For 1 User And Correct Result For Other User.
(Doc ID 2152417.1)
Last updated on APRIL 08, 2022
Applies to:Oracle Spatial and Graph - Version 18.104.22.168 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) than from using the owner.
View A_VUE in one schema (A) with MDSYS.SDO_GEOMETRY column, this view use a view B_VUE in other schema (B)
For this query:
SELECT * FROM A_VUE
WHERE sdo_anyinteract (A_GEOMETRIE, SDO_GEOMETRY(2001, 8265, SDO_POINT_TYPE(-69.90, 49.84, NULL), NULL, NULL)) = 'TRUE';
With only GRANT SELECT ON B_VUE TO A with grant option :
If A query A_VUE no row is returned --> BAD RESULT
If B user query B.B_VUE or A.A_VUE the result is good (same).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document