Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Undocumented Result Cache support functionality.
AUTHID
DEFINER
Dependencies
DBMS_NETWORK_ACL_ADMIN
DBMS_RC_LIB
Documented
No
First Available
11.1
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvtrc.plb
RELIES_ON
Undocumented
dbms_result_cache_internal.relies_on(table_name IN VARCHAR2);
SQL> sho user
USER is "SYS"
SQL> sho con_name
CON_NAME
------------------------------
PDBDEV
SQL> desc dbms_result_cache_internal
PROCEDURE RELIES_ON
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLE_NAME VARCHAR2 IN
SQL> exec dbms_result_cache_internal('UWCLASS.SERVERS');
BEGIN dbms_result_cache_internal('UWCLASS.SERVERS'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DBMS_RESULT_CACHE_INTERNAL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
/* no combination tried, CDB$ROOT, PDB, specify owner, user SYS table produces a different output. */