It's not as easy as you think it should be!
Firstly - avoid using the syspermissions table - use the sys views instead. syspermissions will be removed in later versions of SQL
There is a very popular solution on this link (solution by "Jeremy")
SQL Server query to find all permissions/access for all users in a database[
^] which gives a query for all objects in the database - you should be able to adapt it to your needs