Oracle 12c DBMSZEXP_SYSPKGGRNT Demos

Oracle DBMSZEXP_SYSPKGGRNT Version 12.1.0.1

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.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.

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_ZHELP

Documented

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