ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
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