Windows Authenticated Database Owner

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MichelleM - 04 Oct 2005 21:22 GMT

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.

Reply to this Message

Dan Guzman - 05 Oct 2005 01:50 GMT

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.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

>I think this has happened to me before, but can't seem to find any notes on
>it.
[quoted text clipped - 6 lines]
>
> Thanks in advance.

Reply to this Message