FW: finding "grant exec"

Look at dba_tab_privs. Contrary to the column name in dba_tab_privs the table_name column shows all procedures and packages.

For example:
SYSTEM> grant execute on dbms_pipe to scott;

Grant succeeded.

SYSTEM> select * from dba_tab_privs where grantee = 'SCOTT';

GRANTEE                         TABLE_NAME                           GRANTOR                         PRIVILEGE          

------------------------------  -----------------------------------  ------------------------------  
SCOTT                           DBMS_PIPE                            SYS                             EXECUTE            

Yuval.

-----Original Message-----
From: Fernando Papa [mailto:fpapa_at_elsitio.com.ar] Sent: Wednesday, June 20, 2001 2:57 PM
To: LazyDBA.com Discussion
Subject: finding "grant exec"

Hi everybody!

I have a problem, I did a lots of "grant exec" over a lot of packages
(there's no time to think...), and now I need to know every grant from any
user to a specified package. Somebody know what is the view that hold this information?

Thanks a lot!

--
Fernando O. Papa
DBA
El Sitio - Infraestructura


(54-11) 4339-3854