| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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
PL/SQL procedure successfully completed. |