CODE EXAMPLE FOR SQL

how to check grants on a package in oracle

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