Spatial Query Return Bad Result For A User And Good Result For Other. (Doc ID 2152417.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

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

Scenario:

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

Cause

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