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:[EMAIL PROTECTED]]
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
