Re: Is there a view to know if i have execute privileges on a function?
Date: Wed, 27 Aug 2008 12:09:08 -0300
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.
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.