You should get the details by running the below query..
SELECT grantee FROM all_tab_privs WHERE table_name ='' AND privilege ='EXECUTE' AND grantor ='';
or if you want to limit to Packages or any particular objects try this..
SELECT * FROM all_tab_privs JOIN all_objects ON (table_name = object_name) WHERE table_name ='' AND object_type ='PACKAGE' AND privilege ='EXECUTE' AND grantor ='';
edit | flag
Gokul A Answered on: Oct 10, 2011 at 8:23PM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!