CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [102 users online]    © 2010 psoug.org