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.

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