Seeing as you also asked about P4V and only had command line answers so far, here's what you do for P4V. The "Pending" pane gets you part way to what you want. Ensure the "User" and "Workspace" filters are cleared, and you'll get a list of all files grouped by changelist and client spec. Not as clean as the straight list of files you get when using the P4 command line as suggested by Iain and Mark, but may help in some situations.
An alternative is to create a custom menu in P4V that uses one of the command line solutions suggested. For example:
- Tools->Manage Custom Tools
- New
- Call it something e.g. Open files by user
- Check the "Add to applicable context menus"
- In Application field, browse to p4.exe
- In Arguments, type opened -a %D (the latter takes the currently selected depot path)
- Check the box to run in a console.
I'm sure you could fancy this up a bit if needed to filter the output.