On first use of the controller after a reboot, you're prompted to select which user is playing. Saved games and achievements and whatnot are per-user.

If you've got a child in the household, you're expected to tag their user as such, which imposes some restrictions on their account. Then set up an access code on your user, so the child can't log in as you.