Recomended database owner, MS SQL2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr. Smith - 12 Jul 2008 07:51 GMT

Hi.
What user do you recomend as "default" database owner. I want to avoid it
beeing owned by a "real" person. Is it common to create a local server user
or domain user dedicated to only be a DBO?

Kind regards
Mr. Smith

Reply to this Message

Tibor Karaszi - 12 Jul 2008 08:50 GMT

I usually have "sa" as the database owner (even though nobody ever logs in as "sa". This has the
extra advantage of having the same sid in all SQL Server - no orphaned database owners.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi.
> What user do you recomend as "default" database owner. I want to avoid it beeing owned by a "real"
> person. Is it common to create a local server user or domain user dedicated to only be a DBO?
>
> Kind regards
> Mr. Smith

Reply to this Message

JXStern - 12 Jul 2008 16:56 GMT

>I usually have "sa" as the database owner (even though nobody ever logs in as "sa". This has the
>extra advantage of having the same sid in all SQL Server - no orphaned database owners.

I thought we were all supposed to remove the sa account entirely from
production boxes!

Josh

Reply to this Message

Tibor Karaszi - 12 Jul 2008 19:27 GMT

The thing is that you cannot remove sa. You can rename it, but I still call it "sa". Perhaps I
should say "the login which has SID 0x01" instead? :-)

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

>>I usually have "sa" as the database owner (even though nobody ever logs in as "sa". This has the
>>extra advantage of having the same sid in all SQL Server - no orphaned database owners.
[quoted text clipped - 3 lines]
>
> Josh

Reply to this Message

John Bell - 12 Jul 2008 20:43 GMT

This method still applies if you only have windows authentication, which IMO
makes it even better!

John

> The thing is that you cannot remove sa. You can rename it, but I still
> call it "sa". Perhaps I should say "the login which has SID 0x01" instead?
[quoted text clipped - 9 lines]
>>
>> Josh

Reply to this Message

Dan Guzman - 12 Jul 2008 16:43 GMT

I agree with Tibor to use 'sa' unless you have a reason to do otherwise. In
cases where a non-sa login is desired as the database owner (e.g. third
party application requirement), I usually use a standard SQL login.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

> Hi.
> What user do you recomend as "default" database owner. I want to avoid it
[quoted text clipped - 3 lines]
> Kind regards
> Mr. Smith

Reply to this Message

Mr. Smith - 13 Jul 2008 22:31 GMT

Thanks all of you.
I'll go for sa....

Kind regards
Mr. Smith

>I agree with Tibor to use 'sa' unless you have a reason to do otherwise.
>In cases where a non-sa login is desired as the database owner (e.g. third
[quoted text clipped - 7 lines]
>> Kind regards
>> Mr. Smith

Reply to this Message