Difference between database owner and user who has db-owner?

What is difference between database owner and user in the users folder who
has db-owner?
Database owner has full access under the database. Also user who has db-
owner has full access under the database.
When both create a table, table owner is dbo.
Thanks in advance,
Do.
Message posted via http://www.sqlmonster.com
> When both create a table, table owner is dbo.
No. A user who isn't dbo but is db_owner will now have dbo as owner of the object. This is indeed
the major (and possibly only) difference between being dbo and having the db_owner role.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:48a04eefb96840aea85cee6c4fd2f178@.SQLMonster.c om...
> What is difference between database owner and user in the users folder who
> has db-owner?
> Database owner has full access under the database. Also user who has db-
> owner has full access under the database.
> When both create a table, table owner is dbo.
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com