| Author |
Selecting the database owner
|
|
| Michael M Mason 2005-05-13, 8:23 pm |
| Is there an accepted standard way of deciding who should be the owner
(dbo) for a company database?
When you create a database you are automatically the database owner
for that database. If you use Windows authentication and your user-id
is fred, the database owner will be \\mydomain\fred. But in a
commercial environment should the database be 'owned' by a single
individual? Or should it be owned by sa? Or doesn't it really
matter?
--
Michael
| |
| Hari Prasad 2005-05-14, 3:23 am |
| Hi,
I preferably keep the SA as the database owner. After that I will assign the
DB_OWNER role to the user who required owner access.
Thanks
Hari
SQL Server MVP
"Michael M Mason" <mmmason@ntlworld.com> wrote in message
news:ad8a81lfl41f0m5
vu7jept0adh7perk9oc@
4ax.com...
> Is there an accepted standard way of deciding who should be the owner
> (dbo) for a company database?
>
> When you create a database you are automatically the database owner
> for that database. If you use Windows authentication and your user-id
> is fred, the database owner will be \\mydomain\fred. But in a
> commercial environment should the database be 'owned' by a single
> individual? Or should it be owned by sa? Or doesn't it really
> matter?
>
> --
> Michael
| |
|
| Depends on the requirement and environment
but most of the commercial application have DBO as the owner
"Michael M Mason" <mmmason@ntlworld.com> wrote in message
news:ad8a81lfl41f0m5
vu7jept0adh7perk9oc@
4ax.com...
> Is there an accepted standard way of deciding who should be the owner
> (dbo) for a company database?
>
> When you create a database you are automatically the database owner
> for that database. If you use Windows authentication and your user-id
> is fred, the database owner will be \\mydomain\fred. But in a
> commercial environment should the database be 'owned' by a single
> individual? Or should it be owned by sa? Or doesn't it really
> matter?
>
> --
> Michael
|
|
|
|