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
Export AQ History Tables
AUTHID
CURRENT_USER
Dependencies
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_SYS_EXP_ACTIONS
Documented
No
First Available
Traced back so far to 9i
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
INSTANCE_INFO_EXP
Undocumented
dbms_aq_exp_history_tables.instance_info_exp(
name IN VARCHAR2,
schema IN VARCHAR2,
prepost IN BINARY_INTEGER,
isdba IN BINARY_INTEGER,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER);
RETURN VARCHAR2;
SELECT owner, queue_table, type
FROM dba_queue_tables
ORDER BY 1,2;