Oracle DBMSZEXP_SYSPKGGRNT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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;
/

Related Topics
DBMS_AQADM
Packages
What's New In 12cR1
What's New In 12cR2

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