Re: change Db owner
From: Rulle (rustana@hotmail.com)
Date: 10/15/02
- Next message: Joe Drobnick: "Re: SP4 on SQL 7.0"
- Previous message: Kimberly L. Tripp: "Re: SS Agent Required to Local Admin?"
- In reply to: Steve Thompson: "Re: change Db owner"
- Next in thread: Dan Guzman: "Re: change Db owner"
- Reply: Dan Guzman: "Re: change Db owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Rulle" <rustana@hotmail.com> Date: Tue, 15 Oct 2002 00:24:57 -0700
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: Joe Drobnick: "Re: SP4 on SQL 7.0"
- Previous message: Kimberly L. Tripp: "Re: SS Agent Required to Local Admin?"
- In reply to: Steve Thompson: "Re: change Db owner"
- Next in thread: Dan Guzman: "Re: change Db owner"
- Reply: Dan Guzman: "Re: change Db owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
