• A login doesn't have rights to a database, it has rights to the server. You must create users to access a database and map them as Sugesh has noted.

    Read up on security in Books online to understand principals, logins, and users.