Starting with SQL Server 2005, the sys.fn_my_permissions function can be used.
It has a quite simple syntax:
fn_my_permissions ( securable , 'securable_class')To answer the question, the code would be:
1 2 3 | USE MyDatabase; GO SELECT * FROM fn_my_permissions ('myStoredProcedure', 'OBJECT'); |