Re: Is there a view to know if i have execute privileges on a function?

select * from dba_tab_privs where table_name = '...package..' and privilege = 'EXECUTE' ;

Hans

"Shastry(DBA)" <shastry17_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org
27-08-2008 07:53
Please respond to
shastry17_at_gmail.com

To
oracle-l <oracle-l_at_freelists.org>
cc

Subject
Is there a view to know if i have execute privileges on a function?

Hi Gurus,

Is there a view to know if i have execute privileges on a function or a package or stored procedures?
I have granted execute privilege to a function to an user of different schema. So I am looking for a view to cross check the same whether the user has a execute access to that function. Your advice is highly appreciated.

Thanks,
Ann

Tenzij hierboven anders aangegeven: / Unless stated otherwise above: IBM Nederland B.V.
Gevestigd te Amsterdam
Inschrijving Handelsregister Amsterdam Nr. 33054214

--
http://www.freelists.org/webpage/oracle-l