Oracle | LTPRIV

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	ISUSERALLOWED	REVOKESTATEPRIV
GRANTGRAPHPRIV	ISUSERALLOWEDOPER	REVOKESYSTEMPRIV
GRANTSTATEPRIV	REVOKEGRAPHPRIV	SETUSER
GRANTSYSTEMPRIV

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

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

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

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

Undocumented ltpriv.setUser;

Protected by an ACCESSIBLE BY clause

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