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.
| Author |
Topic |
|
lio2007
Starting Member
8 Posts |
 Posted - 2008-02-20 : 09:29:47
|
| Hi,I have a database which has two db_owner (dbo and a user).The user has left the organization a while ago. Can I remove him or do I need to replace him?What will happen if I remove him?Do I need to keep dbo there also? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-20 : 09:44:42
|
| You will need to run sp_changedbowner before deleting the user. |
 |
|
|
lio2007
Starting Member
8 Posts |
Posted - 2008-02-20 : 09:49:21
|
But do I need to have one specific user? Can I just have dbo?quote:
Originally posted by RickD
You will need to run sp_changedbowner before deleting the user.
|
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-20 : 09:58:12
|
| You can just have dbo. Have a look at BOL (Books Online). |
|
|
|
lio2007
Starting Member
8 Posts |
Posted - 2008-02-20 : 10:21:53
|
| Can I change the owner to the dbo? EXEC sp_changedbowner 'dbo' Or is that not feasible because members of the sysadmin are dbo? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-20 : 11:02:49
|
| As I said, yes you can. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
lio2007
Starting Member
8 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 16:13:34
|
| Dbo maps to specific sql login, you can't drop that login without changing db owner. |
|
|
|
|
|
|
DB_Owner is leaving