Re: User names
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 12/25/04
- Next message: Dan: "dual processor license"
- Previous message: John Bell: "Re: 6.5 to 2000 upgrade - Logon failure..."
- In reply to: Laura K: "Re: User names"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 25 Dec 2004 15:36:55 -0800
I have no idea. I have never upsized from Access.
-- HTH ---------------- Kalen Delaney SQL Server MVP www.SolidQualityLearning.com "Laura K" <klkazanAT@ATcharter.net> wrote in message news:%23UoxqNr6EHA.128@TK2MSFTNGP15.phx.gbl... > 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: Dan: "dual processor license"
- Previous message: John Bell: "Re: 6.5 to 2000 upgrade - Logon failure..."
- In reply to: Laura K: "Re: User names"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
