Re: Oracle Spatial Oracle Label Security

From: Shawn Bisgrove <shawn_bisgrove_at_yahoo.com>
Date: 14 Dec 2001 12:12:32 -0800
Message-ID: <e5926816.0112141212.2e23af8d@posting.google.com>

Update 14 Dec 2001
When the security is applied to the schema using line
execute SA_POLICY_ADMIN.APPLY_SCHEMA_POLICY('DARS_RESOURCES', 'DARS', 'HIDE, READ_CONTROL, LABEL_DEFAULT');
the output of the last few lines is:
first execute as user dars
--Connected.
--select internalidentifier from dars.dataset where
mdsys.sdo_relate(coverage,
--*
--ERROR at line 1:
--ORA-29903: error in executing ODCIIndexFetch() routine
--ORA-13236: internal error in R-tree processing: []
--ORA-13236: internal error in R-tree processing: [Recursive fetch
error]
--ORA-13234: failed to access R-tree-index table [hš J Tš _rt$]
--
--
--Connected.
--
--no rows selected
--
--first execute as user shawn
--Connected.
--select internalidentifier from dars.dataset where
mdsys.sdo_relate(coverage,
--*
--ERROR at line 1:
--ORA-29903: error in executing ODCIIndexFetch() routine
--ORA-13236: internal error in R-tree processing: []
--ORA-13236: internal error in R-tree processing: [Recursive fetch
error]
--ORA-13234: failed to access R-tree-index table
[DATASET_SPATIAL_IDX_rt$]

Received on Fri Dec 14 2001 - 14:12:32 CST