This Contacts View example shows any Contacts created by the User "Web user." Change this to the actual user you are looking for.
This View may be created in the Advanced Search Tool with no additional SQL:
Start Page: Contacts
Please help us improve the KB.