Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
