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
Undocumented
AUTHID
CURRENT_USER
Dependencies
DBMS_AQ_EXP_QUEUES
DBMS_JVM_EXP_PERMS
DBMS_RMGR_PLAN_EXPORT
DBMS_AQ_EXP_ZECURITY
DBMS_RMGR_GROUP_EXPORT
DBMS_ZHELP_LIB
DBMS_AQ_IMP_ZECURITY
DBMS_RMGR_PACT_EXPORT
Documented
No
First Available
Not Known
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
$ORACLE_HOME/rdbms/admin/prvtzhlp.plb
CHECK_SYS_PRIV
Undocumented
dbms_zhelp_ir.check_sys_priv(priv IN BINARY_INTEGER);
SELECT privilege, name
FROM system_privilege_map
ORDER BY 2;
set serveroutput on
BEGIN
dbms_zhelp_ir.check_sys_priv(0);
dbms_zhelp_ir.check_sys_priv(-999999999);
dbms_zhelp_ir.check_sys_priv(999999999);
dbms_zhelp_ir.check_sys_priv(-40);
END;
/
-- No matter what value is provided there is no indication
-- that this does anything except not generate an exception.