you can edit the authenticate user server behaviors on the login page to change the login success redirect.
once logged in, the users ID is stored in a session variable that can be used to return their user information, see the profile page for an example of using the session variable for filtering the users table.