Oracle DBMS_WRR_PROTECTED
Version 21c

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

As can be seen in the demo below this package, or at least parts of it, are protected using the ACCESSIBLE BY clause
Source {ORACLE_HOME}/rdbms/admin/prvtwrr.plb
Subprograms
 
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_WORKLOAD_REPLAY
DBMS_WRR_INTERNAL
DBMS_WRR_REPORT
DBMS_WRR_STATE
DBMS_WRR_STATE_BASE
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx