Oracle DBMS_AQADM_INV
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers? Software Defined Servers can improve performance and security while lowering complexity and cost. With Software Defined Servers you define servers with an optimum configuration to your environment rather than being memory starved and cpu over-provisioned. Find out how you can improve your computing environment with TidalScale. your friends.
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_AQINV
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 12cR2
What's New In 18cR3

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-2017 Daniel A. Morgan All Rights Reserved