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

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.

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


"Mr. Smith" <nospam@nospam.com> wrote in message news:u2qcvu%234IHA.3828@TK2MSFTNGP02.phx.gbl...
> 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
>

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.

--
Hope this s.

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

"Mr. Smith" <nospam@nospam.com> wrote in message
news:u2qcvu%234IHA.3828@TK2MSFTNGP02.phx.gbl...
> 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
>

On Sat, 12 Jul 2008 09:50:58 +0200, "Tibor Karaszi"
<tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote:

>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

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? :-)

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


"JXStern" <JXSternChangeX2R@gte.net> wrote in message
news:q0lh74tc53pgdrliemuh94kpvn4pamu5o8@4ax.com...
> On Sat, 12 Jul 2008 09:50:58 +0200, "Tibor Karaszi"
> <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote:
>
>>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
>

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

John

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote in
message news:A7D23741-48B4-46BD-9A24-1C53BFA19E01@microsoft.com...
> 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?
> :-)
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "JXStern" <JXSternChangeX2R@gte.net> wrote in message
> news:q0lh74tc53pgdrliemuh94kpvn4pamu5o8@4ax.com...
>> On Sat, 12 Jul 2008 09:50:58 +0200, "Tibor Karaszi"
>> <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote:
>>
>>>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
>>
>

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

Kind regards
Mr. Smith
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:6BE65134-9203-4779-BC4A-3529E8245B99@microsoft.com...
>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.
>
> --
> Hope this s.
>
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
>
> "Mr. Smith" <nospam@nospam.com> wrote in message
> news:u2qcvu%234IHA.3828@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>