Check which user has EXECUTE privilege on a package
SELECT grantee, privilege FROM dba_tab_privs WHERE owner = upper(‘&OWNER’) AND table_name = ‘&TABLE_NAME’ AND privilege = ‘EXECUTE’;
Get all the privileges of the current session
select * from session_privs;
