My Oracle Support Banner

Spatial Query Returns Incorrect Result For 1 User And Correct Result For Other User. (Doc ID 2152417.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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