Home -> Usenet -> comp.databases.oracle -> Re: Privileges On Procedures/Functions/Packages

Re: Privileges On Procedures/Functions/Packages

From: mcstock <mcstockx_at_xenquery.com>
Date: Wed, 5 Nov 2003 09:15:24 -0500
Message-ID: <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 Wed Nov 05 2003 - 15:15:24 CET












Original text of this message