Re: User names

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 08:39:19 -0500

No that is a wrong assumption. Unless you specifically list the owner when
you create the object it will be one of two things. If you are logged in as
a dbo or sa it will use dbo as the owner. Otherwise it will use the owner
that you are logged in as. IN the case of EM it is determined by the
account that server was registered under. It is my guess that somewhere
between the two you changed the account or login that you used for what ever
tool you did this through. 

-- 
Andrew J. Kelly  SQL MVP
"Laura K" <klkazanAT@ATcharter.net> wrote in message 
news:OwGs5rX6EHA.1396@tk2msftngp13.phx.gbl...
> Well learned something really important today I thought I would pass on.
>
> The issue was resolved by installing SP3 for SQL server.
>
> Now no matter where I create the tables, now that I have installed the SP, 
> the owner is dbo and not username.  Apparently I was doing everything 
> right (except keeping track of updates).
>
> Laura K
>
>
> "Laura K" <klkazanAT@ATcharter.net> wrote in message 
> news:eWsxhjT6EHA.3504@TK2MSFTNGP12.phx.gbl...
>>I am using a remotely hosted SQL for a website.  The host company has 
>>given me three user names and passwords.  When I create tables either in 
>>the EM or by using Access and upsizing the tables are owned by the user 
>>name.  I need them to be owned by dbo.  What am I doing wrong?
>>
>>
>>
>>
>
>

Relevant Pages

  • Re: ADP: Cant use stored procedure on remote SQL server
    ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: User names
    ... With SP3 will tables created by upsizing from access also be dbo owned as ... Laura ... byjust specifically giving the owner name in QA. ...
    (microsoft.public.sqlserver.server)
  • Re: db_owner role in SQL 2k
    ... Role membership doesn't affect the owner of an object. ... power to create objects owned by other users, including owned by dbo. ... SQL Server MVP ... "John" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • 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: Question about dropping owners permissions...
    ... When a member of the db_owner role creates an object, ... dbo, must the owner must be specified: ... >>> create databases themselves. ... Can anyone help me reach my end goal: Allowing developers to ...
    (microsoft.public.sqlserver.security)