Oracle | DBMS_ZHELP

Oracle DBMS_ZHELP_IR Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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.