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
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.
