Re: Changing DBO
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 09/30/04
- Next message: jack: "Database Corruption"
- Previous message: Kevin McDonnell [MSFT]: "Re: I can only connect via Windows Auth - WHY?"
- In reply to: Volt: "Changing DBO"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 29 Sep 2004 22:51:04 -0500
Below was my response to JLFleming. If this doesn't address your issue,
please elaborate on your issue.
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_changedbowner.
-- Hope this helps. Dan Guzman SQL Server MVP "Volt" <anonymous@discussions.microsoft.com> wrote in message news:397401c4a630$b0ffed60$a501280a@phx.gbl... > Have you sorted it as yet > >>-----Original Message----- >> >>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 >>. >>
- Next message: jack: "Database Corruption"
- Previous message: Kevin McDonnell [MSFT]: "Re: I can only connect via Windows Auth - WHY?"
- In reply to: Volt: "Changing DBO"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
