Gary Jillson (4/24/2015)
I have DB test1. The DB dbo user login is domain\user1. User1 is also part of a security group which has public, datareader and datawriter access to the DB. Is User1 able to make changes to DB test1 since their login is also the dbo login name?
If domain\user1 is the owner of the database, the login domain\user1 maps to the database user dbo, and you should not be able to add domain\user1 as user under its own name in the database.
As the dbo, user1 can do anything in the database.
If they are, how do I change the dbo login name to another domain user or local group i.e. builtin\Administrators?
ALTER AUTHORIZATION ON DATABASE::test1 TO someotheruser
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]