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

This package is protected by an ACCESSIBLE BY clause as demonstrated twice below.
Source {ORACLE_HOME}/rdbms/admin/owmprvs.plb
Subprograms
 
GETPRIVLIST
Undocumented 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
 
GRANTGRAPHPRIV
Undocumented ltpriv.grantGraphPriv(
grantee        IN VARCHAR2,
leaf_workspace IN VARCHAR2,
grantor        IN VARCHAR2,
priv_types     IN VARCHAR2,
node_types     IN VARCHAR2,
admin_option   IN NUMBER);
Protected by an ACCESSIBLE BY clause
 
GRANTSTATEPRIV
Undocumented ltpriv.grantStatePriv(
grantee      IN VARCHAR2,
state        IN VARCHAR2,
grantor      IN VARCHAR2,
priv_types   IN VARCHAR2,
admin_option IN NUMBER);
Protected by an ACCESSIBLE BY clause
 
GRANTSYSTEMPRIV
Undocumented ltpriv.grantSystemPriv(
grantee      IN VARCHAR2,
grantor      IN VARCHAR2,
priv_types   IN VARCHAR2,
admin_option IN NUMBER)
Protected by an ACCESSIBLE BY clause
 
ISUSERALLOWED
Undocumented 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
 
ISUSERALLOWEDOPER
Undocumented ltpriv.isUserAllowedOper(
oper_type        IN NUMBER,
child_workspace  IN VARCHAR2,
parent_workspace IN VARCHAR2,
child_is_mp_leaf IN BOOLEAN)
RETURN BOOLEAN;
Protected by an ACCESSIBLE BY clause
 
REVOKEGRAPHPRIV
Undocumented ltpriv.revokeGraphPriv(
priv_types     IN VARCHAR2,
leaf_workspace IN VARCHAR2,
grantee        IN VARCHAR2,
grantor        IN VARCHAR2,
node_types     IN VARCHAR);
Protected by an ACCESSIBLE BY clause
 
REVOKESTATEPRIV
Undocumented ltpriv.revokeStatePriv(
priv_types IN VARCHAR2,
state      IN VARCHAR2,
grantee    IN VARCHAR2,
grantor    IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REVOKESYSTEMPRIV
Undocumented ltpriv.revokeSystemPriv(
priv_types IN VARCHAR2,
state      IN VARCHAR2,
grantee    IN VARCHAR2,
grantor    IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
SETUSER
Undocumented ltpriv.setUser;
Protected by an ACCESSIBLE BY clause

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WM
LT
LTAQ
LTDDL
LTDTRG
LTI
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_MP_PKG
OWM_VSCRIPT_PKG
OWM_VT_PKG
WM_ERROR
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx