Prev: Checking for Ghost Cleanup Job Status
Next: Unable to script database
From: rgn on 6 Apr 2010 14:11
All,

Currently, the database owner is set to the person (to the person's login id
- sql login or windows login) who creates the database. In almost all the
cases, it is the DBA that creates the databases in our setup. So when “exec
sp_help” is executed it lists all the databases on the server along with
their owner.

As a BEST PRACTICE, who should this owner be set to. The problem with
leaving it on the individual users is that when the person quits and if his
login is removed the owner shows up as NULL when sp_help is executed. Can it
be set to “sa”?

Thanks,
rgn
From: Tibor Karaszi on 7 Apr 2010 03:01
Yes, I prefer sa as owner.

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



"rgn" <rgn(a)discussions.microsoft.com> wrote in message
news:D15028EB-54B0-4758-9236-CD9EEF5A5B94(a)microsoft.com...
> All,
>
> Currently, the database owner is set to the person (to the person's login
> id
> - sql login or windows login) who creates the database. In almost all the
> cases, it is the DBA that creates the databases in our setup. So when
> “exec
> sp_help” is executed it lists all the databases on the server along with
> their owner.
>
> As a BEST PRACTICE, who should this owner be set to. The problem with
> leaving it on the individual users is that when the person quits and if
> his
> login is removed the owner shows up as NULL when sp_help is executed. Can
> it
> be set to “sa”?
>
> Thanks,
> rgn

 | 
Pages: 1
Prev: Checking for Ghost Cleanup Job Status
Next: Unable to script database