Determing rights to execute a package
I've revoked the right to execute a package for PUBLIC, but I can't figure out how to determine that PUBLIC no longer has this privilege. I know PUBLIC has man privileges assigned to it unless they are removed. Can anyone help me here? I've done extensive googling on this.
Lars Breddemann replied
that's an easy one: [Oracle Database Security Guide - Listing Object Privileges Granted to a User|http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/admusers.htm#sthref1578]:
SELECT TABLE_NAME, PRIVILEGE, GRANTABLE FROM DBA_TAB_PRIVS WHERE GRANTEE = 'PUBLIC';