Follow by Email

Tuesday, October 29, 2013

oracle execute privilege on package

 In order to see which roles have execute priviliges on a table/package/any other database object I use below sql query 

SELECT grantee
  FROM all_tab_privs
 WHERE table_name = '<Database object name>'
  AND privilege = 'EXECUTE'

For more details have a look at below stackoverflow thread. http://stackoverflow.com/questions/1255310/how-do-i-check-which-schemata-have-been-granted-execute-permission-on-an-oracle


No comments:

Post a Comment