Re: User names
From: Laura K (klkazanAT_at_ATcharter.net)
Date: 12/25/04
- Next message: Hassan: "Re: high networkio in waitstats"
- Previous message: John Bell: "Re: high networkio in waitstats"
- In reply to: Kalen Delaney: "Re: User names"
- Next in thread: Kalen Delaney: "Re: User names"
- Reply: Kalen Delaney: "Re: User names"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 25 Dec 2004 10:56:21 -0800
With SP3 will tables created by upsizing from access also be dbo owned as
well? The user is a db_owner.
Laura
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:u9TfNZi6EHA.3840@tk2msftngp13.phx.gbl...
>I don't have a pre-sp3 server to try this on, but in sp3, if you are a user
>in the db_owner role, in EM tables that you created will be owned by dbo by
>default.
>
> However, to avoid this confusion, and for other reasons as well, EM is
> really not recommended for creating tables. You have much more control in
> query analyzer by actually using the full table definition statement, and
> explicitly stating the owner name. This could be done prior to sp3 as
> well, byjust specifically giving the owner name in QA.
>
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "Laura K" <klkazanAT@ATcharter.net> wrote in message
> news:OlqMckf6EHA.2180@TK2MSFTNGP10.phx.gbl...
>> 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: "Re: high networkio in waitstats"
- Previous message: John Bell: "Re: high networkio in waitstats"
- In reply to: Kalen Delaney: "Re: User names"
- Next in thread: Kalen Delaney: "Re: User names"
- Reply: Kalen Delaney: "Re: User names"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
