Oracle | DBMS_AQ_EXP

Oracle DBMS_AQ_EXP_ZECURITY Version 21c

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

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