|
Home > Archive > MS SQL Server > December 2006 > What is the difference between dbo schema and db_owner?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What is the difference between dbo schema and db_owner?
|
|
|
| I am new to SQL Server 2005 and according to the installation guide, we have
to link a database user to dbo. It suggests us to choose in schema mapping.
We would like to know what is the difference between dbo schema and db_owner
? It seems that schema is new to SQL Server 20005.
Regards
Peter
| |
| Uri Dimant 2006-12-06, 5:16 am |
| Peter
BOL has a good explanations about the differnces
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ba06f43a-a6a6-48e3-886a-707fe4226858.htm
"Peter" <Peter@discussions.microsoft.com> wrote in message
news:%23A9DMTRGHHA.4712@TK2MSFTNGP04.phx.gbl...
>I am new to SQL Server 2005 and according to the installation guide, we
>have to link a database user to dbo. It suggests us to choose in schema
>mapping.
>
> We would like to know what is the difference between dbo schema and
> db_owner ? It seems that schema is new to SQL Server 20005.
>
> Regards
> Peter
>
| |
|
| Dear Uri,
Thank you for your advice.
From the article, my understanding is there is schema named "dbo schema" and
the user is linked to that schema. On the other hand, there is specific
database role assigned to it.
On the other hand, if we assign db_owner to that database user, it is linked
to the default schema with db_owner database role. Is it correct ?
Peter
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OPngCjRGHHA.3468@TK2MSFTNGP04.phx.gbl...
> Peter
> BOL has a good explanations about the differnces
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ba06f43a-a6a6-48e3-886a-707fe4226858.htm
>
>
>
>
>
>
>
> "Peter" <Peter@discussions.microsoft.com> wrote in message
> news:%23A9DMTRGHHA.4712@TK2MSFTNGP04.phx.gbl...
>
>
| |
| Uri Dimant 2006-12-06, 7:12 pm |
| Peter
There are three things you have to undertsand. A user and schema is
separated in SQL Server 2005. Roles have the same goal as in SQL Server 2000
If you create a user without specifying a schema the default shema 'dbo'
PS. A security in SQL Server is a huge part. You need to spend a few days
to undesrtand it
"Peter" <Peter@discussions.microsoft.com> wrote in message
news:enVpwpRGHHA.3328@TK2MSFTNGP05.phx.gbl...
> Dear Uri,
>
> Thank you for your advice.
>
> From the article, my understanding is there is schema named "dbo schema"
> and the user is linked to that schema. On the other hand, there is
> specific database role assigned to it.
>
> On the other hand, if we assign db_owner to that database user, it is
> linked to the default schema with db_owner database role. Is it correct ?
>
> Peter
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:OPngCjRGHHA.3468@TK2MSFTNGP04.phx.gbl...
>
>
|
|
|
|
|