DBA FUS‎ > ‎

Restricted PL/SQL Packages

posted Sep 13, 2010, 6:17 AM by Sachchida Ojha
select table_name from dba_tab_privs
       where grantee='PUBLIC'
       and privilege ='EXECUTE'
       and table_name in
         ('UTL_SMTP', 'UTL_TCP', 'UTL_HTTP', 'UTL_FILE',
          'DBMS_RANDOM','DBMS_LOB', 'DBMS_SQL','DBMS_JOB',
          'DBMS_BACKUP_RESTORE','DBMS_OBFUSCATION_TOOLKIT');
Comments