Oracle | DRIACC

Oracle DRIACC Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Security privileges utility for Context.

AUTHID CURRENT_USER

Dependencies

CTX_CLS	DBMS_UTILITY	DRVDDLR
CTX_DDL	DRIACCHELP	DRVDOC
CTX_ENTITY	DRIF	DRVODM
CTX_QUERY	DRIPREF	DRVTMT
DBMS_ASSERT	DRIUTIL	DRVUTL
DBMS_PRIV_CAPTURE	DRIXMD	DRVXMD
DBMS_STANDARD	DRUE	DR_DEF

Documented No

First Available 1996

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by CTXSYS with no priivileges granted

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

Subprograms

CAN	SPLIT_SPEC	USER_ACCESS
CHK_ACCESS	UD_ACCESS	VERIFY_PROCEDURE
DEL_CACHE

CAN

Test whether user can access an object driacc.can( p_user IN VARCHAR2, p_access IN VARCHAR2, p_spec IN OUT VARCHAR2) RETURN BOOLEAN;

TBD

CHK_ACCESS (new 23ai)

Ensures that the current user has the given privilege. Currently it only checks for privileges like CREATE ANY TABLE or CREATE ANY INDEX. Using dbms_priv_capture.ses_has_sys_priv driacc.chk_access( p_oname IN VARCHAR2, -- schema p_priv IN VARCHAR2) -- privilege RETURN BOOLEAN;

TBD

DEL_CACHE (new 23ai)

Marks a cache node as invalid driacc.del_cache(p_object IN VARCHAR2);

TBD

SPLIT_SPEC

Parses a spec into distinct parts driacc.split_spec( p_spec IN VARCHAR2, p_type IN VARCHAR2, p_owner IN OUT VARCHAR2, p_object IN OUT VARCHAR2, p_function IN OUT VARCHAR2, p_link IN OUT VARCHAR2);

TBD

UD_ACCESS

Ensures that the index owner can execute the user datastore procedure driacc.ud_access( p_user IN VARCHAR2, p_spec IN VARCHAR2) RETURN BOOLEAN;

TBD

USER_ACCESS

Undocumented driacc.use_access( p_user IN VARCHAR2, p_access IN VARCHAR2, p_owner IN VARCHAR2, p_object IN VARCHAR2) RETURN BOOLEAN;

TBD

VERIFY_PROCEDURE

Verifies that a package or procedure exists and is owned by CTXSYS driacc.verify_proceure( p_user IN VARCHAR2, -- schema p_spec IN OUT VARCHAR2) -- object name RETURN BOOLEAN;

TBD