check permission on procedure or function

[maswien]

How do I check if a user has execute permission on a procedure? Which view I can use?

Thanks

 

[carp]

To check somebody else's privileges, use dba_tab_privs. To check your own, use all_tab_privs.

 

[maswien]

I'm little confused, why I need check a view that shows user's permissions on tables while I want to know user's permissions on procedures.

 

[SantaMufasa]

...why I need check a view that shows user's permissions on tables while I want to know user's permissions on procedures.

...Because in Oracle's infinite wisdom <grin>, they poorly named the view "DBA_TAB_PRIVS" when, instead, they should have named the view "DBA_OBJ_PRIVS".


Here is a proof-of-concept of what Dave (Carp) is saying:

grant execute on xyz to doh;
select privilege, table_name
  from dba_tab_privs
 where grantee = 'DOH';

PRIVILEGE                                TABLE_NAME
---------------------------------------- ----------
EXECUTE                                  XYZ

Let us know if you have additional questions.



Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[maswien]

Thanks carp and Mufasa!

I guess that doesn't matter, as long as people map things correctly in brain, they should be fine.