Oracle | DBMS_AQADM

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	I_PARSE_NAME	KWQA_3GL_CHECKSYSPRIVCUSR
EXECUTE_STMT2	KWQA_3GL_CHECKQUEPRIV	PARSE_NAME
EXECUTE_STMTCUSR	KWQA_3GL_CHECKSYSPRIV	PARSE_SCHEMA
EXECUTE_STMTCUSR2

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