Oracle | DRIACCHELP

Oracle DRIACCHELP Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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	DBA_TAB_COLUMNS	DRUE
DBA_PROCEDURES	DBA_TAB_PRIVS	DR_DEF
DBA_ROLE_PRIVS	DR$INDEX	SYSAUTH$
DBA_SYNONYMS	DRIACC	_BASE_USER
DBA_SYS_PRIVS	DRIUTL

Documented No

First Available 12.2

Security Model Owned by CTXSYS with no privileges granted

Direct access to this package is prevented by means of an Accessible By clause.

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

Subprograms

CLOSE_ROLE_PRIVS	FETCH_ROLE_PRIVS	GET_TAB_PRIVS
DO_SYN	GET_ROLE_DIRECT	OPEN_ROLE_PRIVS

CLOSE_ROLE_PRIVS

Undocumented driacchelp.close_role_privs(c_role_privs IN sys_refcursor);

TBD

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

FETCH_ROLE_PRIVS

driacchelp.fetch_role_privs( c_role_privs IN sys_refcursor, l_role OUT VARCHAR2) RETURN NUMBER;

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

      FROM dual;

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

      *

      ERROR at line 1:

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

GET_TAB_PRIVS

Undocumented driacchelp.get_tab_privs( cv_system_pattern IN VARCHAR2, p_user IN VARCHAR2, p_access IN VARCHAR2, p_owner IN VARCHAR2, p_object IN VARCHAR2) RETURN NUMBER;

TBD

OPEN_ROLE_PRIVS

Undocumented driacchelp.open_role_privs( p_user IN VARCHAR2, c_role_privs OUT sys_refcursor);

TBD