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 |
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
 Posted - 2002-01-25 : 18:49:16
|
| I don't see any articles or forum posts that seem to address this, so I'll ask the group: Who should be the database owner? We consistently make dbo the owner for tables and views, but what about for the database itself? We have numerous small databases, and I create most of them. Therefore, I am listed as the Owner in the database information. But I'm a contractor, and I'll leave here one day (we use Mixed Security, primarily SQL logins). We have about 6 users with SysAdmin privileges, and no one uses the SA account.Does the listed database owner in this case really matter? I know I can use sp_changedbowner to set it to something else. Should it be set to SA (some of them are that way now)? Is there a way to specify the owner in the CREATE DATABASE statement (didn't see it in BOL)?Your thoughts are appreciated...MarkP.S. SQL 7, SP 3 on NT 4. Soon to be upgraded to SQL2K on Win2KAS.--------------------------------There's a new General in town... |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-25 : 19:15:17
|
| Personally, I try to always change the database owner to sa. My reasoning is that this is one login that is always guaranteed to be on every server... Even more importantly, it is always guaranteed to have the same sid. So this ensures that even if I move the database to another server, the dbo user will always be mapped correctly. I'd love to hear other points of view though...Edited by - izaltsman on 01/25/2002 19:16:15 |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-01-25 : 19:25:56
|
...well, tough. I never though about it until this post, but now that I've read your opinion I must say I totally agree with your reasoning. It makes excellent sense and eliminates a lot of potential problems. SO THERE!  |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-01-28 : 11:39:36
|
| I've never really thought about it either, but I agree that sa is the best way to go. I've always been in the habit to set every db owner to sa, don't know how or why... just always have. Now I have a reason!Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
|
|
Best Practice: Database Owner