strangely, it's DBA_TAB_PRIVS (and related views like ALL_TAB_PRIVS,
ALL_TAB_PRIVS_RECD, etc.)
also, there's no object_type column in this very old view, so you need to
join with DBA_OBJECTS (or a related view) if you are looking for privs on a
specified object type
another anomaly in the data dictionary: you'll find VIEW column definitions
in DBA_TAB_COLUMNS
--
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048
"Aakash" <daakash_at_yahoo.com> wrote in message
news:83fd0b82.0311050520.7b2f4ae2_at_posting.google.com...
> hi,
>
> can anyone tell me which tables/views to refer to find
> the "execute" privileges given on objects like
> procdure/functions/packages ?
>
> its urgent .... any help will be appreciated.
>
> regards,
