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:

Symptoms

When running a spatial queries on views using another user and not the owner, the result is different (incorrect) than from using the owner.

For example:

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).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.