Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 More than 1 db_owner

Author  Topic 

lio2007
Starting Member

8 Posts

Posted - 2008-02-20 : 10:43:16
Hi,

I have a database which contains 5 db_owner. If I need to remove two of them (they have left the company and are not being replaced) so db_changedowner is out of the question.

What is the proper way to do this?

Do I need to transfer their ownerships to one of the existing db_owner?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-02-20 : 14:17:16
There can only be one user that owns the database, which is different from dbo. If one of them does, then switch the ownership to an existing account that has dbo privileges, then drop the users.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -