Re: db_owner role in SQL 2k

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 15:32:38 -0700

Hi John

Role membership doesn't affect the owner of an object. The default owner of
an object is the user who created it. Someone in the db_owner role still has
their own user name. However, a user in the db_owner role does have the
power to create objects owned by other users, including owned by dbo. But
the user has to explicitly list the owner name when creating the object:

CREATE TABLE dbo.NEW_TABLE
 ( .....) 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"John" <anonymous@discussions.microsoft.com> wrote in message
news:0b7901c46e83$9424b020$a601280a@phx.gbl...
> I have added a new user in the db_owner role in SQL 2k.
> When this user creates a table or any other DB object, it
> is owned by the user and not by dbo even though the ID is
> a part of DBO. Is this a default behavior in SQL 2k or do
> I need to do something different in order for the object
> to be owned by DBO.
>
> Thanks.
>
> John

Relevant Pages

  • Re: rda push when owner is not dbo.
    ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)
  • Re: Full-Text Catalog does not build...
    ... John, thank you. ... from time to time during population I have got event about SQL ... Server machine has 6GB RAM, SQL Server uses AWE and has 5GB memory. ... dbo properties PK_properties 7 1 cat_neu_prop1 ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Inconsistent Search Results
    ... Thanks for replying, John - here is the stuff you asked for, though I can't ... send you the SQL query itself, though it isd interesting to Note that if I ...
    (microsoft.public.sqlserver.fulltext)
  • Re: db_owner role in SQL 2k
    ... there is never any confusion or mistaking as to who it should be. ... Andrew J. Kelly SQL MVP ... "John" wrote in message ... > a part of DBO. ...
    (microsoft.public.sqlserver.programming)
  • SQLCE Push pb on VB.Net Compact Framework
    ... I'm using RDA to sync the ce db with a sql server db. ... I have SQL Server tables with "dbo" owner and some have specific owner. ... The tables with owner "dbo" are sync with no pb - the pull and the push ...
    (microsoft.public.sqlserver.programming)