Oracle DBMS_AQADM_INV
Version 21c

General Information
Library Note Morgan's Library Page Header
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.
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
 
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
 
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 21c
What's New In 23c

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