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
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, '21.1', nblock);
dbms_output.put_line(retVal);
dbms_output.put_line(cstring);
dbms_output.put_line(TO_CHAR(nblock));
END;
/ SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_AQADM TO "AQ_ADMINISTRATOR_ROLE"');
SYS
1
