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
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