how to check grants on a package in oracle

Solutions on MaxInterview for how to check grants on a package in oracle by the best coders in the world

Search
showing results for - "how to check grants on a package in oracle"
Jeanne
04 May 2018
1SELECT grantee, privilege
2  FROM dba_tab_privs
3 WHERE owner = 'owner'
4   AND table_name = 'object_name'		-- Package, procedure...
5   AND privilege = 'EXECUTE'
similar questions
check oracle versionoracle list packagesoracle list usersoracle grantshow to check schema privileges in oracleoracle service name vieworacle list user defined typesoracle user quota unlimitedoracle query to see what scema i am working inhow to get list of synonyms in oracleoracle show grants on tablehow to know the character set of an oracle databesoracle privileges usersoracle list privilegesoracle owner vieworacle user last connectedoracle list service namesoracle job historyoracle show execution planoracle list jobsoracle current session detailsoracle list rulesoracle list user grants
queries leading to this page
oracle list grants on procedureoracle list grants on packagehow to check grants on a package in oracle