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