It's a Windows Login, security is set to Windows auth.
When you map a login to a database, you first check the chekbox in the to section of the user mapping screen (you select the DB). Then in the bottom part, you assign a db role (db_owner in this case).
By default the user is mapped to the login, you click on Ok and it's "normally" done. Then problem is when I go back, the login is not mapped to the DB (the checkbox is not selected), but I can see that db_owner is still checked in the db role section. Since the DB is not checked in the top part, the bottom part is grayed (disabled), but I still can see that db_owner is checked.
If I re-check the checkbox for that DB (top section) and then click on ok (the db_owner is already selected), it does not change a thing. If I try to script that last action, I'm being notified that there is nothing to script.
This happends on different DBs and different users. My only work around is complete destruction of the logins/users/schemas.
The accounts gets created on the DB.