Can you try this:

select a.object_name
from all_objects a, all_tab_privs b
where a.object_type in ('PROCEDURE','FUNCTION','PACKAGE')
and a.object_name=b.table_name
and (b.grantee='user' or b.grantee='PUBLIC') ;

Hope it helpful to you!


Tang Qiang