Oracle | LTPRIV

Oracle LTPRIV Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Workspace Manager Privilege Management 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 an Accessible By clause.

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');

             *

      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

          *

      PLS-00904: insufficient privilege to access object LTPRIV

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 Daniel Morgan. Last Updated:

This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved