list of post of one user only

Hi there
I’m looking for module/hack that shows posts of only one user. I’ve found https://www.dagondesign.com/articles/posts-by-author-plugin-for-wordpress/ that shows user last posts on the post it’s self. But what i need is URL of his posts or MYSQL question that will lead to his posts…

Regards