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
Unknown Advanced Queuing Administration
AUTHID
CURRENT_USER
Dependencies
DBMS_APPLY_ADM
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_PRVTSQDS
DBMS_AQADM
DBMS_ASSERT
DBMS_PRVTSQIS
DBMS_AQADM_LIB
DBMS_LOGREP_UTIL
DBMS_RULE_ADM
DBMS_AQADM_SYS
DBMS_PROPAGATION_INTERNAL
DBMS_STREAMS_ADM_UTL
DBMS_AQADM_SYSCALLS
DBMS_PRVTAQIM
DBMS_SYSTEM
DBMS_AQADM_VAR
DBMS_PRVTAQIP
DBMS_SYS_ERROR
DBMS_AQINT_LIB
DBMS_PRVTAQIS
DBMS_TRANSFORM_EXIMP
DBMS_AQJMS
Documented
No
First Available
18.1
Security Model
Owned by SYS with no privilege granted
Direct access to this package is prevented by means of an Accessible By clause.
dbms_aqadm_inv.i_parse_name(
name_type IN BINARY_INTEGER,
full_name IN VARCHAR2,
default_schema IN VARCHAR2,
schema OUT VARCHAR2,
name OUT VARCHAR2,
dblink_db OUT VARCHAR2,
dblink_dom OUT VARCHAR2,
dblkconq OUT VARCHAR2,
external IN BOOLEAN);
dbms_aqadm_inv.parse_name(
name_type IN BINARY_INTEGER,
full_name IN VARCHAR2,
schema OUT VARCHAR2,
name OUT VARCHAR2,
dblink_db OUT VARCHAR2,
dblink_dom OUT VARCHAR2,
dblkconq OUT VARCHAR2,
external IN BOOLEAN,
default_schema IN VARCHAR2);
exec dbms_aqadm_inv.parse_schema('UWCLASS');
BEGIN dbms_aqadm_inv.parse_schema('UWCLASS'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DBMS_AQADM_INV
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored