Oracle DBMS_AQ_EXP_ZECURITY
Version 18.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Advanced Queueing Export Privilege Checking
AUTHID CURRENT_USER
Dependencies
DBMS_AQ_EXP_CMT_TIME_TABLES DBMS_AQ_EXP_QUEUES DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES DBMS_AQ_EXP_QUEUE_TABLES DBMS_AQ_SYS_EXP_INTERNAL
DBMS_AQ_EXP_HISTORY_TABLES DBMS_AQ_EXP_SIGNATURE_TABLES DBMS_ZHELP_IR
DBMS_AQ_EXP_INDEX_TABLES DBMS_AQ_EXP_SUBSCRIBER_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);
exec dbms_aq_exp_zecurity.check_export_priv('C##SH');
Overload 2 dbms_aq_exp_zecurity.check_export_priv(obj_id IN NUMBER);
SQL> SELECT object_name, object_id
2 from dba_objects
3 where owner = 'C##SH'
4 and rownum < 11
5* order by 1
SQL> /

OBJECT_NAME           OBJECT_ID
-------------------- ----------
ADDRESS_TYPE              77427
CAL_MONTH_SALES_MV        76449
CAL_MONTH_SALES_MV        76759
CHANNELS                  76450
CHANNELS_DIM              76764
CHANNELS_PK               76451
COSTS                     76452
COSTS                     76453
COSTS                     76454
COSTS                     76455

exec dbms_aq_exp_zecurity.check_export_priv(76453);

Related Topics
Built-in Functions
Built-in Packages
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
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
DBMS_AQ_IMP_ZECURITY
What's New In 18c
What's New In 19c

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
  DBSecWorx