SQL · 2011-10-25

SQL Server – Find Stored Procedures User Can Access

http://msdn.microsoft.com/en-us/library/ms190310.aspx

Returns a report that has information about user permissions for an object, or statement permissions, in the current database.

See Microsoft link above for complete capabilities.