Getting Stored Procedure Permission details in Sql Server.

select U.name,
O.name,
permission_name 
from 
sys.database_permissions
join sys.sysusers U on grantee_principal_id = uid
join sys.sysobjects O on major_id = id
where O.name like 'sp_name'
order by U.name;