Re: User names

From: Laura K (klkazanAT_at_ATcharter.net)
Date: 12/24/04

  • Next message: Hassan: "unit of waitime in DBCC SQLPERF(waitstats)" 
    Date: Fri, 24 Dec 2004 12:42:41 -0800

    Nope I tested it in the EM before I added the SP. My username was the
    owner. I tested it again an hour later and after installing the SP and dbo
    was the owner.

    I do not have the ability to change the account or username. I can not log
    into the server as a dbo or sa. It is remotely hosted by my web hosting
    company. My user name is a database owner but that made no difference before
    the SP. My only access is through the EM or the QA or through my website.
    The only way I can log in is with my assigned username and password as given
    to me by crystaltech my host company. If I change my account it is only
    done via email with a password and the host company must manually do it.

    Laura

    "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
    news:u4PR83b6EHA.1392@tk2msftngp13.phx.gbl...
    > 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?
    >>>
    >>>
    >>>
    >>>
    >>
    >>
    >
    >

  • Next message: Hassan: "unit of waitime in DBCC SQLPERF(waitstats)"

    Relevant Pages

    • Re: Viewing Forms in ADP
      ... to create will be owned by dbo and will have dbo as their owner. ... also use any other username as the owner but some of the features of ADP may ... controls who don't have a Record Source Qualifier property. ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Change name Owner in XP Home Edition
      ... can anyone tell me how to change the user name 'Owner' in XP Home ... Right click on the username, select properties, change the username. ... A better way would be to create a new user with a proper username and copy ... the old user profile to the new users profile directory with FAST or better ...
      (microsoft.public.windowsxp.security_admin)
    • Re: XP pro password help..
      ... just re-format the whole thing. ... With the chached accounts for the you may not ... > have the right username and password combo, ... I did call the previous owner and she ...
      (microsoft.public.win2000.security)
    • How to sum cells based on conditions
      ... username ... Each time a unique case number is encountered, check Col D (case owner name) ... 2004-05-020 Theresa Chan 2 Theresa Chan ... case 1993-01-115 owner is Jane Doe and total ...
      (microsoft.public.excel.worksheet.functions)
    • RE: How to sum cells based on conditions
      ... username ... Each time a unique case number is encountered, check Col D (case owner name) ... 2004-05-020 Theresa Chan 2 Theresa Chan ... case 1993-01-115 owner is Jane Doe and total ...
      (microsoft.public.excel.worksheet.functions)