Determing rights to execute a package

[george_hamilton]

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.

[lbreddemann · Accepted solution]

Hi George,

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

best regards,

Lars