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

Assuming you want to know if your user has the privilege, use sqlplus to connect with the user and try one of the following:

• desc owner.function_name OR desc owner.package_name (if function is inside a package)
• select privilege from all_tab_privs where table_name='FUNCTION_OR_PACKAGE_NAME';

Maybe you have the privilege to execute the function/package through a role, so I guess the desc is the simplest way to check the privilege.

Regards,
Cerri

2008/8/27 Shastry(DBA) <shastry17_at_gmail.com>

> 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
>

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