You can generate application-specific passwords and then see/revoke those passwords on your google.com/accounts page.
From the screenshots (don't have access yet) it seems that you don't get to specify the type of application or access, but I would assume there is some limitation on what you can do with these passwords?