Oracle DBMS_AQADM_INV
Version 18.3

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_AQADM DBMS_AQJMS DBMS_PRVTAQIS
DBMS_AQADM_LIB DBMS_AQ_SYS_IMP_INTERNAL DBMS_PRVTSQDS
DBMS_AQADM_SYS DBMS_ASSERT DBMS_PRVTSQIS
DBMS_AQADM_SYSCALLS DBMS_PRVTAQIM DBMS_SYSTEM
Documented No
First Available 18.1.0.0
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
 
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 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 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

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 18c
What's New In 19c

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