Oracle | AA

Oracle OWM_DML_PKG 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 Oracle Wallet Manager (OWM) Utilities

AUTHID DEFINER

Dependencies

LT	WM$EV_I_TRIG	WM$VET_I_TRIG
LTADM	WM$HT_I_TRIG	WM$VET_U_TRIG
LTUTIL	WM$MGWT_I_TRIG	WM$VTH_I_TRIG
UD_TRIGS	WM$MPWT_I_TRIG	WM$VTH_U_TRIG
WM$CP_I_TRIG	WM$RT_I_TRIG	WM$WPT_D_TRIG
WM$CP_U_TRIG	WM$RWT_I_TRIG	WM$WPT_I_TRIG
WM$CT_I_TRIG	WM$SAV_I_TRIG	WM$WPT_U_TRIG
WM$CT_U_TRIG	WM$UDP_I_TRIG	WM$WST_I_TRIG
WM$EI_I_TRIG	WM$UD_U_TRIG	WM$WT_I_TRIG
WM$EI_U_TRIG	WM$UI_I_TRIG	WM$WT_U_TRIG

First Available 12.1

Security Model Owned by WMSYS with no privileges granted

This package is protected from direct use by an ACCESSIBLE BY clause and demonstrated below.

Source {ORACLE_HOME}/rdbms/admin/owmwdmls.plb
{ORACLE_HOME}/rdbms/admin/owmwdmlb.plb

Subprograms

WM$COLUMN_PROPS$F	WM$MP_PARENT_WORKSPACES_T$F	WM$VERSIONED_TABLES$F
WM$CONSTRAINTS_TABLE$F	WM$RESOLVE_WORKSPACES_TABLE$F	WM$VT_ERRORS_TABLE$F
WM$ENV_VARS$F	WM$RIC_TABLE$F	WM$WORKSPACES_TABLE$F
WM$EVENTS_INFO$F	WM$SYSPARAM_ALL_VALUES$F	WM$WORKSPACE_PRIV_TABLE$F
WM$HINT_TABLE$F	WM$UDTRIG_DISPATCH_PROCS$F	WM$WORKSPACE_SAVEPOINTS_T$F
WM$MP_GRAPH_WORKSPACES_TABLE$F	WM$UDTRIG_INFO$F

WM$COLUMN_PROPS$F

Undocumented owm_dml_pkg.wm$column_props$f(identity_type IN VARCHAR2) RETURN NUMBER;

TBD

WM$CONSTRAINTS_TABLE$F

Undocumented owm_dml_pkg.wm$constraints_table$f( constraint_type IN VARCHAR2, status IN VARCHAR2, index_type IN VARCHAR2) RETURN NUMBER;

TBD

WM$ENV_VARS$F

Undocumented owm_dml_pkg.wm$env_vars$f(hidden_v IN NUMBER) RETURN NUMBER;

conn wmsys

      Password: 

      

      SELECT wmsys.owm_dml_pkg.wm$env_vars$f(1)

      FROM dual;

      SELECT wmsys.owm_dml_pkg.wm$env_vars$f(1)

      *

      ERROR at line 1:

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

WM$EVENTS_INFO$F

Undocumented owm_dml_pkg.wm$events_info$f(capture IN VARCHAR2) RETURN NUMBER;

TBD

WM$HINT_TABLE$F

Undocumented owm_dml_pkg.wm$hint_table$f(isdefault IN NUMBER) RETURN NUMBER;

conn wmsys

      Password: 

      

      SELECT wmsys.owm_dml_pkg.wm$hint_table$f(1)

      FROM dual;

      SELECT wmsys.owm_dml_pkg.wm$hint_table$f(1)

      *

      ERROR at line 1:

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

WM$MP_GRAPH_WORKSPACES_TABLE$F

Undocumented owm_dml_pkg.wm$mp_graph_worksapces_table$f(mp_graph_flag IN VARCHAR2) RETURN NUMBER;

TBD

WM$MP_PARENT_WORKSPACES_T$F

Undocumented owm_dml_pkg.wm$mp_parent_worksapces_t$f( isrefreshed IN NUMBER, parent_flag IN VARCHAR2) RETURN NUMBER;

TBD

WM$RESOLVE_WORKSPACES_TABLE$F

Undocumented owm_dml_pkg.wm$resolve_workspaces_table$f(oldfreezemode IN VARCHAR2) RETURN NUMBER;

TBD

WM$RIC_TABLE$F

Undocumented owm_dml_pkg.wm$ric_table$f( my_mode IN VARCHAR2, status IN VARCHAR2) RETURN NUMBER;

TBD

WM$SYSPARAM_ALL_VALUES$F

Undocumented owm_dml_pkg.wm$sysparam_all_values$f( isdefault IN VARCHAR2, hidden_v IN NUMBER) RETURN NUMBER;

TBD

WM$UDTRIG_DISPATCH_PROCS$F

Undocumented owm_dml_pkg.wm$udtrig_dispatch_proc$f(trig_flag IN NUMBER) RETURN NUMBER;

TBD

WM$UDTRIG_INFO$F

Undocumented owm_dml_pkg.wm$udtrig_info$f( trig_flag IN NUMBER, status IN VARCHAR2, internal_type IN VARCHAR2, event_flag IN NUMBER) RETURN NUMBER;

TBD

WM$VERSIONED_TABLES$F

Undocumented owm_dml_pkg.wm$versioned_tables$f( disabling_ver IN VARCHAR2, hist IN VARCHAR2, validtime IN NUMBER, bl_savepoint IN VARCHAR2, bl_check_for_duplicates IN VARCHAR2, bl_single_transaction IN VARCHAR2, identity_type IN VARCHAR2) RETURN NUMBER;

TBD

WM$VT_ERRORS_TABLE$F

Undocumented owm_dml_pkg.wm$vt_errors_table$f(status IN VARCHAR2) RETURN NUMBER;

TBD

WM$WORKSPACES_TABLE$F

Undocumented owm_dml_pkg.wm$workspaces_table$f( freeze_status IN VARCHAR2, freeze_mode IN VARCHAR2, wm_lockmode IN VARCHAR2, isrefreshed IN NUMBER, session_duration IN NUMBER, cr_status IN VARCHAR2, keep IN NUMBER) RETURN NUMBER;

TBD

WM$WORKSPACE_PRIV_TABLE$F

Undocumented owm_dml_pkg.wm$workspace_priv_table$f( priv IN VARCHAR2, admin IN NUMBER) RETURN NUMBER;

TBD

WM$WORKSPACE_SAVEPOINTS_T$F

Undocumented owm_dml_pkg.wm$workspace_savepoints_t$f(is_implicit IN NUMBER) RETURN NUMBER;

TBD