Re: User names
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 12/25/04
- Next message: Hassan: "high networkio in waitstats"
- Previous message: tony mays: "Case Sensitivity in Unique Indexes and Constraints"
- In reply to: Laura K: "Re: User names"
- Next in thread: Laura K: "Re: User names"
- Reply: Laura K: "Re: User names"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Dec 2004 18:05:39 -0800
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: "high networkio in waitstats"
- Previous message: tony mays: "Case Sensitivity in Unique Indexes and Constraints"
- In reply to: Laura K: "Re: User names"
- Next in thread: Laura K: "Re: User names"
- Reply: Laura K: "Re: User names"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
