Oracle DBMS_AQ_IMP_ZECURITY
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Not documented but appears to return no error if the current user has DBMS_AQ import privileges.
AUTHID CURRENT_USER
Dependencies
DBMS_AQ_IMP_INTERNAL DBMS_ZHELP_IR  
Documented No
First Available Traced back so far to 9i
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
 
CHECK_IMPORT_PRIV
Undocumented dbms_aq_imp_zecurity.check_import_priv;
conn / as sysdba

exec dbms_aq_imp_zecurity.check_import_priv;

Related Topics
Advanced Queuing Demo 1
Advanced Queuing RAC Demo
DBMS_AQ
DBMS_AQADM
DBMS_AQELM
DBMS_AQINV
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
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