Oracle | DBMS_AQADM

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	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

      -- 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