Re: dictionary view of GRANT EXECUTE?

A copy of this was sent to bikle_at_my-deja.com (if that email address didn't require changing) On Tue, 17 Aug 1999 01:25:51 GMT, you wrote:

>Hi,
>
>I'm looking for a dictionary view which tells me who has
>issued successful GRANT EXECUTE commands
>
>The views work well for privileges granted to tables
>and roles but I cannot find a list of users who have
>been granted EXECUTE on my packages
>

it is in there along with tables and views:

SQL> select owner, table_name, grantor, grantee from dba_tab_privs   2 where privilege = 'EXECUTE'

gets it for you.

>-Dan
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 17 1999 - 07:11:39 CDT