My current project requires that data be filtered based on the credentials of the current user.
The solution - a little magic in the view definition.
In a view, you can specify the following in the 'where' clause of the CAML:
<FieldRef Name="MyColumnToFilterData" />
The only requirement is that the column my be of type 'Person or Group'.
See here for more information.