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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-22 : 08:07:06
|
| SQLUser writes "difference between DBO vs db_ownerdbo is a user and it is a part of db_owner fixed database role?can you explain?--------------The DBO user is always a member of the db_owner role, but not every user in the role is the user DBO-------------------" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-22 : 09:08:42
|
| dbo is a user.It's a permanent member of db_owner.You can add other users to db_owner, but not every user is part of db_owner.Anyone who is a part of db_owner will have the same permissions as dbo. Anyone who is not part of db_owner will not have the same permissions as dbo.??? Are you looking for something specific here?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
DBO vs db_Owner