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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.