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
Undocumented Advanced Queuing related internal
package. About the only thing we can find that might give a hint to its
purpose is the following:
SQL> desc dba_queue_partition_assignment_table
ERROR:
ORA-04043: object dba_queue_partition_assignment_table does
not exist
SQL> desc dba_queue_partition_assignment_table
ERROR:
ORA-04043: object dba_queue_partition_assignment_table does
not exist
SQL> desc all_queue_partition_assignment_table
ERROR:
ORA-04043: object all_queue_partition_assignment_table does
not exist
SQL> desc user_queue_partition_assignment_table
Name Null? Type
------------------ -------- --------------------------
OWNER NOT NULL VARCHAR2(128)
QUEUE_ID NOT NULL NUMBER
QUEUE_NAME NOT NULL VARCHAR2(128)
SUBSCRIBER_ID NOT NULL NUMBER
SUBSCRIBER_NAME NOT NULL VARCHAR2(128)
SESSION_ID NOT NULL NUMBER
GROUP_LEADER NOT NULL NUMBER
PARTITION_ID NUMBER
VERSION# NUMBER
INST_ID NOT NULL NUMBER
FLAGS NUMBER
CLIENT_ID VARCHAR2(128)
CLIENT_VERSION VARCHAR2(128)
AUDIT_SID NUMBER
CREATE_TIME TIMESTAMP(6) WITH TIME ZONE
and the most interesting thing about it is that there isn't a CDB, DBA, or
ALL version of the view.
dbms_teqk.aq$_connect_me(
schema IN VARCHAR2,
queue_name IN VARCHAR2,
subscriber_name IN VARCHAR2,
inst_id OUT NUMBER,
url OUT NUMBER,
flags IN OUT NUMBER,
p_list OUT
sys.dbms_teqk.partition_list);