Re: Privileges On Procedures/Functions/Packages

thanks for the help mark.
its really strange that DBA_TAB_PRIVS shud have info abt objects like procs/funcs etc. i was at my wits end trying to figure out where possibly they cud be. thanks again

"mcstock" <mcstockx_at_xenquery.com> wrote in message news:<7Y6dnT8YZM-xmzSiRVn-ig_at_comcast.com>...
> 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,
> > aakash
Received on Thu Nov 06 2003 - 06:01:10 CET