Re: Changing DBO
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 09/29/04
- Previous message: Kevin McDonnell [MSFT]: "RE: How to retrieve the certificate that SQL server using"
- In reply to: JLFleming: "Changing DBO"
- Next in thread: Volt: "Changing DBO"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 28 Sep 2004 19:13:03 -0500
You need to first change the ownership of the existing objects to 'dbo'
using sp_changeobjectowner. You can then remove the existing database user
using sp_revokedbaccess and change database ownership to that account with
sp_changedbowenr.
-- Hope this helps. Dan Guzman SQL Server MVP "JLFleming" <anonymous@discussions.microsoft.com> wrote in message news:0c0a01c4a57a$d354f510$a601280a@phx.gbl... > > I have assigned an SQL account as DBO of a database. I > am going to change the DBO to a Windows login account. > When I run the sp_changedbowner stored procedure, will > change the owner of the objects created by the SQL > account? The table objects have the SQL account as the > owner. If not, will I have to run the > sp_changeobjectowner too? > > > Thank you, > JLFleming
- Previous message: Kevin McDonnell [MSFT]: "RE: How to retrieve the certificate that SQL server using"
- In reply to: JLFleming: "Changing DBO"
- Next in thread: Volt: "Changing DBO"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
