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
DataPump Private Internal Utilities
AUTHID
CURRENT_USER
Dependencies
DUAL
LTUTIL
USER_WM_PRIVS
LT
LT_CTX_PKG
USER_WORKSPACES
LTADM
OWM_MP_PKG
WM_ERROR
LTI
PLITBLM
Documented
No
First Available
Not known
Security Model
Owned by WMSYS with no privileges granted.
Direct access to this package is prevented by means of an Accessible By clause.
ltpriv.getPrivList(state IN VARCHAR2) RETURN VARCHAR2;
SELECT wmsys.ltpriv.getPrivList('ZZYZX') FROM dual;
SELECT wmsys.ltpriv.getPrivList('ZZYZX') FROM dual
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object LTPRIV
ltpriv.grantGraphPriv(
grantee IN VARCHAR2,
leaf_workspace IN VARCHAR2,
grantor IN VARCHAR2,
priv_types IN VARCHAR2,
node_types IN VARCHAR2,
admin_option IN NUMBER);
ltpriv.isUserallowed(
priv_type IN VARCHAR2,
state IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
IF wmsys.ltpriv.isUserallowed('ZZYZX', 'ZZYZX') THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
IF wmsys.ltpriv.isUserallowed('ZZYZX', 'ZZYZX') THEN
*
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00904: insufficient privilege to access object LTPRIV
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored