Oracle | DBMS_WRR

Oracle DBMS_WRR_PROTECTED Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Supporting utilities for Workload Replay

AUTHID CURRENT_USER

Dependencies

ALL_OBJECTS	DBMS_WORKLOAD_CAPTURE_I	DBMS_WRR_INTERNAL
DBMS_PRIV_CAPTURE	DBMS_WORKLOAD_CAPTURE_LIB	PRVT_SMGUTIL
DBMS_STANDARD	DBMS_WORKLOAD_REPLAY	XS_ADMIN_UTIL
DBMS_SYS_ERROR	DBMS_WORKLOAD_REPLAY_I	X$DBREPLAY_PATCH_INFO
DBMS_WORKLOAD_CAPTURE	DBMS_WORKLOAD_REPLAY_LIB	XS_ADMIN_UTIL

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

Direct access to some objects in this package is prevented by means of an Accessible By clause.

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

Subprograms

CHECK_DIR_ACCESS	GET_DBVERSION_NUM	INVOKE_XCACHE_FREE
CHECK_RAT_PRIVILEGE	GET_DBVERSION_TXT	INVOKE_XCACHE_LOAD
GET_DBREPLAY_PATCH_INFO	INVOKE_SIMPLE_CMD

CHECK_DIR_ACCESS

Undocumented dbms_wrr_protected.dcheck_dir_access( dir IN VARCHAR2, check_write IN BOOLEAN);

TBD

CHECK_RAT_PRIVILEGE

Undocumented dbms_wrr_protected.check_rat_privilege(auth_type IN BINARY_INTEGER);

exec dbms_wrr_protected.check_rat_privilege(1);

           *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_WRR_PROTECTED

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

GET_DBREPLAY_PATCH_INFO (new 21c)

Undocumented dbms_wrr_protected.get_dbreplay_patch_info RETURN VARCHAR2;

SELECT dbms_wrr_protected.get_dbreplay_patch_info

      FROM dual;

      SELECT dbms_wrr_protected.get_dbreplay_patch_info

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object DBMS_WRR_PROTECTED

GET_DBVERSION_NUM

Undocumented but assumed to returned the database version in numeric form dbms_wrr_protected.get_dbversion_num RETURN NUMBER;

SQL> SELECT dbms_wrr_protected.get_dbversion_num

        2  FROM dual;

      SELECT dbms_wrr_protected.get_dbversion_num

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object DBMS_WRR_PROTECTED

GET_DBVERSION_TXT

Undocumented but assumed to return the database version number in text form dbms_wrr_protected.get_dbversion_txt RETURN VARCHAR2;

SQL> SELECT dbms_wrr_protected.get_dbversion_txt

        2  FROM dual;

      SELECT dbms_wrr_protected.get_dbversion_txt

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object DBMS_WRR_PROTECTED

INVOKE_SIMPLE_CMD

Undocumented but is likely performing a dynamic SQL execution

Overload 1 dbms_wrr_protected.invoke_simple_cmd( cmd_num IN BINARY_INTEGER, ret_str OUT VARCHAR2) RETURN NUMBER;

TBD

Overload 2 dbms_wrr_protected.invoke_simple_cmd(cmd_num IN BINARY_INTEGER) RETURN NUMBER;

TBD

INVOKE_XCACHE_FREE

Undocumented dbms_wrr_protected.invoke_xcache_free;

exec dbms_wrr_protected.invoke_xcache_free;

INVOKE_XCACHE_LOAD

Undocumented dbms_wrr_protected.invoke_xcache_load( sql_stmt IN VARCHAR2, num_ub4_defines IN BINARY_INTEGER, num_str_defines IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD