When a user is added to a database, a row is added to the sysusers system table in that database. Once a user has an entry in the sysusers table of a database, the user can use and open that database, and use that database as the default database.