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" <da*****@yahoo.com> wrote in message
news:83**************************@posting.google.c om...
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,
aakash