Oracle DBMS_ZHELP_IR
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
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.

Related Topics
DBMS_ZHELP
Object Privileges
Packages
System Privileges
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved