Oracle DBMS_AQADM_INV
Version 21c

General Information
Library Note Morgan's Library Page Header
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

It appears that this package is protected by means of an ACCESSIBLE BY Clause
Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
Subprograms
 
EXECUTE_STMT
Execute statement dbms_aqadm_inv.execute_stmt(
client_stmt          IN VARCHAR2,
ignore_ddl_dml_error IN BOOLEAN);
TBD
 
EXECUTE_STMT2
Execute statement dbms_aqadm_inv.execute_stmt2(
stmt             IN VARCHAR2,
ignore_ddl_error IN BOOLEAN,
system_cursor    IN BOOLEAN,
ignore_comperr   IN BOOLEAN);
TBD
 
EXECUTE_STMTCUSR
Execute statement cursor dbms_aqadm_inv.execute_stmtcusr(
stmt                 IN VARCHAR2,
current_user         IN VARCHAR2,
ignore_ddl_dml_error IN BOOLEAN);
TBD
 
EXECUTE_STMTCUSR2
Execute statement cursor dbms_aqadm_inv.executestmtcusr2(
stmt             IN VARCHAR2,
current_user     IN VARCHAR2,
ignore_ddl_error IN BOOLEAN,
ignore_comperr   IN BOOLEAN);
TBD
 
I_PARSE_NAME
Undocumented 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);
TBD
 
KWQA_3GL_CHECKQUEPRIV
Check Queue Privileges dbms_aqadm_inv.kwqa_3gl_checkQuePriv(
q_schema     IN VARCHAR2,
q_name       IN VARCHAR2,
priv         IN BINARY_INTEGER,
current_user IN VARCHAR2);
TBD
 
KWQA_3GL_CHECKSYSPRIV
Undocumented

Protected by an ACCESSIBLE BY clause
dbms_aqadm_inv.kwqa_3gl_checkSysPriv(
obj_schema IN VARCHAR2,
syspriv    IN BINARY_INTEGER);
exec dbms_aqadm_inv.kwqa_3gl_checkSysPriv('SYS', 1);
 *
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

-- this is likely  an issue with the ACCESSIBLE BY clause
 
KWQA_3GL_CHECKSYSPRIVCUSR
Undocumented

Protected by an ACCESSIBLE BY clause
dbms_aqadm_inv.kwqa_3gl_checkSysPrivCusr(
current_user IN VARCHAR2,
obj_schema   IN VARCHAR2,
syspriv      IN BINARY_INTEGER);
exec dbms_aqadm_inv.kwqa_3gl_checkSysPrivCusr(USER, 'C##SH', 0);
 *
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

-- this is likely  an issue with the ACCESSIBLE BY clause
 
PARSE_NAME
Undocumented 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);
TBD
 
PARSE_SCHEMA
Undocumented

Protected by an ACCESSIBLE BY clause
dbms_aqadm_inv.parse_schema(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

Related Topics
Built-in Functions
Built-in Packages
DBMS_ALERT
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_IMP_ZECURITY
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx