Oracle | DBMS_AQ_EXP

Oracle DBMS_AQ_EXP_ZECURITY Version 23c

General Information

Library Note

Morgan's Library Page Header

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);

exec dbms_aq_exp_zecurity.check_export_priv('C##SH');

Overload 2 dbms_aq_exp_zecurity.check_export_priv(obj_id IN NUMBER);

SELECT object_name, object_id

      FROM dba_objects

      WHERE owner = 'C##SH'

      AND rownum < 11

      ORDER BY 1;

      

      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);