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.
dbms_aqjms.aq$_add_nondurable_subscriber(
queue IN VARCHAR2,
rule IN VARCHAR2,
transformation IN VARCHAR2,
client_session_guid IN OUT VARCHAR2,
subscriber_name OUT VARCHAR2);
dbms_aqjms.aq$_add_subscriber(
queue IN VARCHAR2,
subscriber IN sys.aq$agent,
rule IN VARCHAR2,
transformation IN VARCHAR2,
secure_q IN BINARY_INTEGER,
delivery_mode IN BINARY_INTEGER,
queue_to_queue IN BOOLEAN);
dbms_aqjms.aq$_alter_subscriber(
queue IN VARCHAR2,
subscriber IN sys.aq$_agent,
rule IN VARCHAR2);
TBD
Undocumented
Overload 2
dbms_aqjms.aq$_alter_subscriber(
queue IN VARCHAR2,
subscriber IN sys.aq$agent,
rule IN VARCHAR2,
transformation IN VARCHAR2,
secure_q IN BINARY_INTEGER);
dbms_aqjms.aq$_jms_dequeue_bytes_messages(
queue_name IN VARCHAR2,
num_messages IN BINARY_INTEGER,
consumer_name IN VARCHAR2,
dequeue_mode IN BINARY_INTEGER,
navigation IN BINARY_INTEGER,
visibility IN BINARY_INTEGER,
wait IN BINARY_INTEGER,
correlation IN VARCHAR2,
deq_condition IN VARCHAR2,
signature IN sys.aq$sig_prop,
transformation IN VARCHAR2,
message_props OUT sys.aq$_jms_message_properties
messages OUT sys.aq$_jms_bytes_messages,
msgids OUT sys.aq$_jms__array_msgids,
num_dequeued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_dequeue_map_messages(
queue_name IN VARCHAR2,
num_messages IN BINARY_INTEGER,
consumer_name IN VARCHAR2,
dequeue_mode IN BINARY_INTEGER,
navigation IN BINARY_INTEGER,
visibility IN BINARY_INTEGER,
wait IN BINARY_INTEGER,
correlation IN VARCHAR2,
deq_condition IN VARCHAR2,
signature IN sys.aq$_sig_prop,
transformation IN VARCHAR2,
message_props OUT sys.aq$#_jms_message_properties,
messages OUT sys.aq$_jms_map_messages,
msgids OUT sys.aq$_jms_array_msgids,
num_dequeued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_dequeue_messages(
queue_name IN VARCHAR2,
num_messages IN BINARY_INTEGER,
consumer_name IN VARCHAR2,
dequeue_mode IN BINARY_INTEGER,
navigation IN BINARY_INTEGER,
visibility IN BINARY_INTEGER,
wait IN BINARY_INTEGER,
correlation IN VARCHAR2,
deq_condition IN VARCHAR2,
signature IN sys.aq$_sig_prop,
transformation IN VARCHAR2,
message_props OUT sys.aq$#_jms_message_properties,
messages OUT sys.aq$_jms_messages,
msgids OUT sys.aq$_jms_array_msgids,
num_dequeued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_dequeue_obj_messages(
queue_name IN VARCHAR2,
num_messages IN BINARY_INTEGER,
consumer_name IN VARCHAR2,
dequeue_mode IN BINARY_INTEGER,
navigation IN BINARY_INTEGER,
visibility IN BINARY_INTEGER,
wait IN BINARY_INTEGER,
correlation IN VARCHAR2,
deq_condition IN VARCHAR2,
signature IN sys.aq$_sig_prop,
transformation IN VARCHAR2,
message_props OUT sys.aq$#_jms_message_properties,
messages OUT sys.aq$_jms_object_messages,
msgids OUT sys.aq$_jms_array_msgids,
num_dequeued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_dequeue_str_messages(
queue_name IN VARCHAR2,
num_messages IN BINARY_INTEGER,
consumer_name IN VARCHAR2,
dequeue_mode IN BINARY_INTEGER,
navigation IN BINARY_INTEGER,
visibility IN BINARY_INTEGER,
wait IN BINARY_INTEGER,
correlation IN VARCHAR2,
deq_condition IN VARCHAR2,
signature IN sys.aq$_sig_prop,
transformation IN VARCHAR2,
message_props OUT sys.aq$#_jms_message_properties,
messages OUT sys.aq$_jms_stream_messages,
msgids OUT sys.aq$_jms_array_msgids,
num_dequeued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_dequeue_text_messages(
queue_name IN VARCHAR2,
num_messages IN BINARY_INTEGER,
consumer_name IN VARCHAR2,
dequeue_mode IN BINARY_INTEGER,
navigation IN BINARY_INTEGER,
visibility IN BINARY_INTEGER,
wait IN BINARY_INTEGER,
correlation IN VARCHAR2,
deq_condition IN VARCHAR2,
signature IN sys.aq$_sig_prop,
transformation IN VARCHAR2,
message_props OUT sys.aq$#_jms_message_properties,
messages OUT sys.aq$_jms_text_messages,
msgids OUT sys.aq$_jms_array_msgids,
num_dequeued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_enqueue_bytes_messages(
queue_name IN VARCHAR2,
messages IN sys.aq$_jms_byte_messages,
num_messages IN BINARY_INTEGER,
message_props IN sys.aq$#_jms_message_properties,
visibility IN BINARY_INTEGER,
relative_msgid IN RAW,
sequence_deviation IN BINARY_INTEGER,
transformation IN VARCHAR2,
msgids OUT sys.aq$_jms_array_msgids,
errors OUT sys.aq$_jms_array_errors,
num_enqueued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_enqueue_map_messages(
queue_name IN VARCHAR2,
messages IN sys.aq$_jms_map_messages,
num_messages IN BINARY_INTEGER,
message_props IN sys.aq$#_jms_message_properties,
visibility IN BINARY_INTEGER,
relative_msgid IN RAW,
sequence_deviation IN BINARY_INTEGER,
transformation IN VARCHAR2,
msgids OUT sys.aq$_jms_array_msgids,
errors OUT sys.aq$_jms_array_errors,
num_enqueued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_enqueue_messages(
queue_name IN VARCHAR2,
messages IN sys.aq$_jms_messages,
num_messages IN BINARY_INTEGER,
message_props IN sys.aq$#_jms_message_properties,
visibility IN BINARY_INTEGER,
relative_msgid IN RAW,
sequence_deviation IN BINARY_INTEGER,
transformation IN VARCHAR2,
msgids OUT sys.aq$_jms_array_msgids,
errors OUT sys.aq$_jms_array_errors,
num_enqueued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_enqueue_obj_messages(
queue_name IN VARCHAR2,
messages IN sys.aq$_jms_object_messages,
num_messages IN BINARY_INTEGER,
message_props IN sys.aq$#_jms_message_properties,
visibility IN BINARY_INTEGER,
relative_msgid IN RAW,
sequence_deviation IN BINARY_INTEGER,
transformation IN VARCHAR2,
msgids OUT sys.aq$_jms_array_msgids,
errors OUT sys.aq$_jms_array_errors,
num_enqueued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_enqueue_str_messages(
queue_name IN VARCHAR2,
messages IN sys.aq$_jms_stream_messages,
num_messages IN BINARY_INTEGER,
message_props IN sys.aq$#_jms_message_properties,
visibility IN BINARY_INTEGER,
relative_msgid IN RAW,
sequence_deviation IN BINARY_INTEGER,
transformation IN VARCHAR2,
msgids OUT sys.aq$_jms_array_msgids,
errors OUT sys.aq$_jms_array_errors,
num_enqueued OUT BINARY_INTEGER);
dbms_aqjms.aq$_jms_enqueue_text_messages(
queue_name IN VARCHAR2,
messages IN sys.aq$_jms_text_messages,
num_messages IN BINARY_INTEGER,
message_props IN sys.aq$#_jms_message_properties,
visibility IN BINARY_INTEGER,
relative_msgid IN RAW,
sequence_deviation IN BINARY_INTEGER,
transformation IN VARCHAR2,
msgids OUT sys.aq$_jms_array_msgids,
errors OUT sys.aq$_jms_array_errors,
num_enqueued OUT BINARY_INTEGER);
dbms_aqjms.aq$_register(
schema IN VARCHAR2,
subname IN VARCHAR2,
protocol IN VARCHAR2,
host IN VARCHAR2,
port_no IN VARCHAR2,
presentation IN BINARY_INTEGER,
version IN BINARY_INTEGER);
dbms_aqjms.get_db_username_for_agent(
agent_name IN VARCHAR2,
owner_name IN VARCHAR2,
queue_name IN VARCHAR2,
operation IN BINARY_INTEGER,
curr_db_user IN VARCHAR2,
db_username OUT VARCHAR2,
enq_priv OUT BINARY_INTEGER,
deq_priv OUT BINARY_INTEGER);
dbms_aqjms.search_boolean_property(
memctx IN RAW,
property_name IN VARCHAR2,
owner IN VARCHAR2,
queue IN VARCHAR2,
row_id IN VARCHAR2,
ifheaderproperty IN NUMBER)
RETURN NUMBER;
dbms_aqjms.search_double_property(
memctx IN RAW,
property_name IN VARCHAR2,
owner IN VARCHAR2,
queue IN VARCHAR2,
row_id IN VARCHAR2,
ifheaderproperty IN NUMBER)
RETURN DOUBLE;
dbms_aqjms.search_number_property(
memctx IN RAW,
property_name IN VARCHAR2,
owner IN VARCHAR2,
queue IN VARCHAR2,
row_id IN VARCHAR2,
ifheaderproperty IN NUMBER)
RETURN NUMBER;
dbms_aqjms.search_string_property(
memctx IN RAW,
property_name IN VARCHAR2,
owner IN VARCHAR2,
queue IN VARCHAR2,
row_id IN VARCHAR2,
ifheaderproperty IN NUMBER)
RETURN VARCHAR2;
dbms_aqjms.subscriber_exists(
queue_name IN VARCHAR2,
subscriber IN sys.aq$_agent,
in_subscr_type IN NUMBER,
subscr_type OUT NUMBER,
rule_name OUT VARCHAR2,
trans_name OUT VARCHAR2,
ruleset OUT VARCHAR2,
result OUT NUMBER);
TBD
Undocumented
Overload 2
dbms_aqjms.subscriber_exists(
queue_name IN VARCHAR2,
subscriber IN sys.aq$_agent,
in_subscr_type IN NUMBER,
subscr_type OUT NUMBER,
rule_name OUT VARCHAR2,
trans_name OUT VARCHAR2,
ruleset OUT VARCHAR2,
negative_ruleset OUT VARCHAR2,
result OUT NUMBER);