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
Oracle Workspace Manager utilities
AUTHID
CURRENT_USER
Dependencies
ALL_USERS
DBA_SYS_PRIVS
LTRIC
CDB_OBJECTS
DBA_TABLES
LTUTIL
CDEF$
DBA_TAB_COLS
LT_CTX_PKG
CON$
DBA_TRIGGERS
LT_EXPORT_PKG
DBA_CONSTRAINTS
DBA_TRIGGERS
OBJ$
DBA_OBJECTS
DBMS_DATAPUMP
OWM_ASSERT_PKG
DBA_OPERATORS
DBMS_REGISTRY
OWM_DDL_PKG
DBA_QUEUES
DBMS_STANDARD
PLITBLM
DBA_ROLES
DBMS_UTILITY
V$OPTION
DBA_ROLE_PRIVS
LT
V$PARAMETER
DBA_SEQUENCES
LTI
WM_DDL_UTIL
DBA_SYNONYMS
Documented
No
First Available
Not known
Security Model
Owned by WMSYS with no privileges granted
Direct access to some objects in this package is prevented by means of an Accessible By clause.
exec wmsys.owm_vscript_pkg.startQueue;
BEGIN wmsys.owm_vscript_pkg.startQueue; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object STARTQUEUE
owm_vscript_pkg.stopQueue(dropqueueandtable IN BOOLEAN);
exec wmsys.owm_vscript_pkg.stopQueue(FALSE);
BEGIN wmsys.owm_vscript_pkg.stopQueue(FALSE); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object STOPQUEUE
owm_vscript_pkg.wm$addRecord(
col1 IN VARCHAR2,
col2 IN VARCHAR2,
col3 IN VARCHAR2,
col4 IN VARCHAR2,
col5 IN VARCHAR2,
ctype IN VARCHAR2,
firste IN BOOLEAN);
owm_vscript_pkg.wm$checkExistingRecord(
col1_v IN VARCHAR2,
col2_v IN VARCHAR2,
col3_v IN VARCHAR2,
col4_v IN VARCHAR2,
col5 IN VARCHAR2,
common IN VARCHAR2,
ctype IN VARCHAR2);
Appears to be protected by an Accessible By clause
owm_vscript_pkg.wm$convertVersionStr(version_str IN VARCHAR2) RETURN VARCHAR2;
SELECT wmsys.owm_vscript_pkg.wm$convertVersionStr('21.3')
FROM dual;
SELECT wmsys.owm_vscript_pkg.wm$convertVersionStr('21.3')
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object WM$CONVERTVERSIONSTR
Returns TRUE if the identified table column exists, else FALSE
owm_vscript_pkg.wm$hasColumn(
tab_name IN VARCHAR2,
colname IN VARCHAR2,
schema IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
IF wmsys.owm_vscript_pkg.wm$hasColumn('T', 'TESTCOL', 'C##UWCLASS') THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/ T
Returns TRUE if the identified object exists, else FALSE
owm_vscript_pkg.wm$objectExists(
obj_name IN VARCHAR2,
obj_owner IN VARCHAR2,
obj_type IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
IF wmsys.owm_vscript_pkg.wm$objectExists('T', 'C##UWCLASS', 'TABLE') THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/ T