Search the Reference Library pages:  

Oracle DBMS_ZHELP_IR
Version 11.1
 
General
Source $ORACLE_HOME/rdbms/admin/prvtzhlp.plb
Dependencies
DBMS_ZHELP_LIB
Security Model Execute is granted to PUBLIC
 
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
System Privileges
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----