Oracle 12cR2 DBMSZEXP

Oracle DBMSZEXP_SYSPKGGRNT Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.

Purpose Generates the SQL for DBMS_UTILITY.EXEC_DDL_STATEMENT to grant EXECUTE on DBMS_AQADM to the AQ_ADMINISTRATOR_ROLE role

AUTHID DEFINER

Dependencies

DBMS_ASSERT

DBMS_STANDARD

DBMS_ZHELP

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE and EXP_FULL_DATABASE roles.

Source {ORACLE_HOME}/rdbms/admin/prvtzexp.plb

SYSTEM_INFO_EXP

Generate SQL to create grant dbmszexp_syspkggrnt( prepost IN BINARY_INTEGER, connectstring OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       retVal  VARCHAR2(128);

       cstring VARCHAR2(128);

       nblock  PLS_INTEGER;

      BEGIN

        retVal := dbmszexp_syspkggrnt.system_info_exp(1, cstring, '12.1', nblock);

        dbms_output.put_line(retVal);

        dbms_output.put_line(cstring);

        dbms_output.put_line(TO_CHAR(nblock));

      END;

      /