I also wanted something similar recently and used this article to get the list!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=172689

You may want to set a filter in the at the end as: loginname='<required user>'

Hope this helps!