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
Advanced Queueing Export Privilege Checking
AUTHID
CURRENT_USER
Dependencies
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_SYS_EXP_INTERNAL
DBMS_AQ_EXP_QUEUES
DBMS_ZHELP_IR
DBMS_AQ_EXP_QUEUE_TABLES
Documented
No
First Available
Not Known
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
CHECK_EXPORT_PRIV
Validates the user has AQ export privileges
Overload 1
dbms_aq_exp_zecurity.check_export_priv(obj_schema IN VARCHAR2);