Oracle DBMS_RESULT_CACHE

Oracle DBMS_RESULT_CACHE_INTERNAL Version 18.3

General Information

Library Note

Morgan's Library Page Header

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 suppor functionality.

AUTHID DEFINER

Dependencies

DBA_OBJECTS

DBMS_NETWORK_ACL_ADMIN

DBMS_RC_LIB

Documented No

First Available 11.1.0.6

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtrc.plb

Subprograms

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. */