Re: change Db owner
From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 10/15/02
- Next message: Eric: "sp_change_users_login doesn't work for me"
- Previous message: d@d.com: "Using Application role with a VB Data Control"
- In reply to: Rulle: "Re: change Db owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Dan Guzman" <danguzman@nospam-earthlink.net> Date: Tue, 15 Oct 2002 08:42:02 -0500
You can specify a standard SQL login (e.g. 'sa') regardless of the
authentication mode. Since the 'sa' login must always exist, you will
never have problems with 'dbo' user mapping when your database is owned
by 'sa'.
-- Hope this helps. Dan Guzman SQL Server MVP ----------------------- SQL FAQ links (courtesy Neil Pike): http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 http://www.sqlserverfaq.com http://www.mssqlserver.com/faq ----------------------- "Rulle" <rustana@hotmail.com> wrote in message news:295601c2741b$f72b8a40$35ef2ecf@TKMSFTNGXA11... > Ok, what I understand is that I better use the sa > as "default" owner. But what if I was only using "Windows > Authentication" security, what's then the solution to > avoid orphaned objects etc? > > /Rulle > > > >-----Original Message----- > >"Rulle" <rustana@hotmail.com> wrote in message > >news:0d1e01c27062$439d3f80$2ae2c90a@phx.gbl... > >> I want to change the db owner for a database to a > windows > >> group that a found by executing sp_helplogins: > >> > >> sp_changedbowner 'domain\windowsusergroup' > >> > >> The query analyzer refuses, and says that the login > >> doesn't exist. Is it not possible to make a > winusergroup a > >> dbo? > > > >Groups will not work in this instance, you'll need to > assign a database > >"owner" that is a user login account. > > > >> It is possible to put my WIN2000 login as the owner, > could > >> that cause any problem? What happens when I quit for > >> instance. > > > >You could, but then that will likely lead to referencing > issues as all > >objects in the database will owned under your account. > Broken or orphaned > >ownership chains are common with this scenario. You may > want to consider > >keeping the owner as 'sa'... > > > >Steve > > > > > >. > >
- Next message: Eric: "sp_change_users_login doesn't work for me"
- Previous message: d@d.com: "Using Application role with a VB Data Control"
- In reply to: Rulle: "Re: change Db owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
