Re: Windows Authenticated Database Owner

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/05/05 

Date: Tue, 4 Oct 2005 19:50:27 -0500

Without a valid database owner login, you may have problems with some
functionality. Some items that come to mind are:

    - Enterprise Manager security management
    - sp_helpdb
    - cross-database chaining ('db chaining' database option)

It's a trivial task to change the database owner to a valid login using
sp_changedbowner so I suggest you go ahead and fix it. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"MichelleM" <MichelleM@discussions.microsoft.com> wrote in message 
news:D1D9CEF0-F7C5-4D99-9155-C3EDF3372A5E@microsoft.com...
>I think this has happened to me before, but can't seem to find any notes on 
>it.
>
> I've got a windows-authenticated login that is the database owner.  Login
> cleanup occurs in Windows, and the login is dropped.  What is the impact 
> on
> the database that still references this windows-authenticated login as its
> dbo?  I think this causes some problems, but can't confirm that.
>
> Thanks in advance.

Relevant Pages

  • Re: Roles & Users
    ... "John Bell" wrote in message ... >> I think just saying things like 'dbo is the database owner' can lead to ... >> It is the user name assumed by the login listed in sysdatabases as the ...
    (microsoft.public.sqlserver.server)
  • Re: Event ID 28005; Error 15517
    ... If this database was restored from another server, the login that is the ... database owner (and therefore the login that becomes dbo) does not exist on ... try changing the database owner by running: ...
    (microsoft.public.sqlserver.security)
  • Re: change users login for dbo user
    ... You'd want to change the database owner using ... procedure in books online. ... >dbo instead of a SQL server login. ... >but it indicates this sp cannot be used for dbo user. ...
    (microsoft.public.sqlserver.security)
  • Re: Who should be DB owner
    ... 'SA' will be the best login for database owner, ... There are chances that ... (As seen under the database properties.) ...
    (microsoft.public.sqlserver.setup)