Oracle DRIACCHELP
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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 (new 12.2)
Undocumented driacchelp.close_role_privs(c_role_privs IN sys_refcursor);
TBD
 
DO_SYN (new 12.2)
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 (new 12.2)
  driacchelp.fetch_role_privs(
c_role_privs IN  sys_refcursor,
l_role       OUT VARCHAR2)
RETURN NUMBER;
TBD
 
GET_ROLE_DIRECT (new 12.2)
  driacchelp.get_role_privs(
p_user IN VARCHAR2,
p_role IN VARCHAR2)
RETURN NUMBER;
TBD
 
GET_TAB_PRIVS (new 12.2)
  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 (new 12.2)
  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 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved