Is it possible to play Rock Band with multiple accounts from the same machine?
After much searching on the Rock Band forums, I found this post which seems to confirm that it is not possible on PS3. So only one account can be achieving goals at a time (although you can choose whether you want to have multiple people achieving goals for that one account).