CODE EXAMPLE FOR SQL

oracle list grants on procedure

SELECT grantee, privilege
  FROM dba_tab_privs
 WHERE owner = 'owner'
   AND table_name = 'object_name'		-- Package, procedure...
   AND privilege = 'EXECUTE'