Execute Privilege

[hbks]

Hello All,

In which Catalog Table i can check whether 'EXECUTE' privilege exists or not on any Stored Procedure ??

'dba_tab_privs' catalog table gives information like Select,Insert,delete,update privileges on table, But on any Stored Procedure how to see the 'EXECUTE' privilege is there or not ?

Thanks in Advance,

HBKS

 

[JtheRipper]

Hi there,

DBA_TAB_PRIVS does tell you whether a stored procedure has execute privileges granted on it or not, if you do not see anything it probably means that the procedure does not have execute permissions on it.

Regards,
Jaco