Oracle | DRIACCHELP

Oracle DRIACCHELP 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 Security privileges utility for Context.

Direct demos of this package's functionality cannot be written due to Oracle's use of the ACCESSIBLE BY clause (see Security Model).

AUTHID DEFINER

Dependencies

DBA_OBJECTS	DBATAB_COLUMNS	DRUE
DBA_PROCEDURES	DR$INDEX	DR_DEF
DBA_ROLE_PRIVS	DRIACC	_BASE_USER
DBA_SYNONYMS

Documented No

First Available 12.2

Security Model Owned by CTXSYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause only allowing access from DRIACC

Source {ORACLE_HOME}/ctx/admin/driacchelp.pkh
{ORACLE_HOME}/ctx/admin/driacchelp.plb

Subprograms

DO_SYN

GET_ROLE_DIRECT

DO_SYN

Takes in an object owner and name and tries to follow synonym links to find out the real owner and name. Then verifies that the base object exists. RETURNs TRUE if the base object exists, else FALSE driacchelp.do_syn( p_objtype IN VARCHAR2, p_owner IN OUT VARCHAR2, p_object IN OUT VARCHAR2, p_func IN OUT VARCHAR2, p_link IN OUT VARCHAR2) RETURN BOOLEAN;

TBD

GET_ROLE_DIRECT

Undocumented driacchelp.get_role_direct( p_user IN VARCHAR2, p_role IN VARCHAR2) RETURN NUMBER;

conn ctxsys/ctxsys@pdbdev

      

      SELECT ctxsys.driacchelp.get_role_direct('UWCLASS', 'DBA');

             *

      ORA-06553: PLS-904: insufficient privilege to access object DRIACCHELP