EXECUTE privilege on a procedure

[RamHardikar]

Hi,

in which dictionary view could i see if a role has got EXECUTE privilege on a procedure?

 

[SantaMufasa]

Ram,

Here is an example of your scenario:

SQL> create role ram;

Role created.

SQL> grant execute on bogus to ram;

Grant succeeded.

select privilege, grantee, table_name
from user_tab_privs
where privilege = 'EXECUTE';

PRIVILEGE       GRANTEE         TABLE_NAME
--------------- --------------- -------------
EXECUTE         RAM             BOGUS

Let us know if this resolves your question.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[RamHardikar]

Mufasa,

Thanks a lot it has helped.