Oracle DRIACCHELP
Version 18.3

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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.0.1
Security Model Owned by CTXSYS with no privileges granted
ACCESSIBLE BY (PACKAGE driacc)
Source {ORACLE_HOME}/ctx/admin/driacchelp.pkh
Subprograms
 
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
  driacchelp.get_role_privs(
p_user IN VARCHAR2,
p_role IN VARCHAR2)
RETURN NUMBER;
TBD
 
GET_TAB_PRIVS
  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
  driacchelp.open_role_privs(
p_user       IN  VARCHAR2,
c_role_privs OUT sys_refcursor);
TBD

Related Topics
Built-in Functions
Built-in Packages
What's New In 18cR3
What's New In 19cR3

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