Check if the schema have grant permissions - oracle

102
Views
1
Answers

How do I check if a schema have execute permissions on the objects?

edit | flag
William Patrick
Asked on: Oct 10, 2011 at 8:14PM

1 Answers

64
4
64

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

Search

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!

Browse Categories

Browse Tags