Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question