Re: how to remap dbo alias
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Feb 2006 20:06:32 -0600
The login specified as the new dbowner should get mapped as the new 'dbo'
user regardless of the @map specification. Did you refresh Enterprise
Manager?
Note that the @map parameter indicates that existing *aliases* are remapped.
The dbo user is always remapped to the specified login. Aliases are a
backwards compatibility feature that allows multiple logins to be mapped to
the same database user.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"MunchingBill" <munchingbill@xxxxxxxxxxxxxxxxx> wrote in message
news:8FBEDA24-8F33-4FD7-BE5C-BE9B318D305C@xxxxxxxxxxxxxxxx
Using Sqlserver 2000. We recently changed the ownership of a database
using
sp_changedbowner 'new_owner', true. According to BOL, when the second
argument is true, the existing dbo alias for that database should be
remapped
to new_owner. Although the database ownership did change to new_owner, the
Users display still shows dbo mapped to the old owner. Am I using
sp_changedbowner correctly? How do I remap the dbo user in that database
to
the new owner?
--
MunchingBill
.
- Prev by Date: Re: Who is using MSMQ?
- Next by Date: Re: 'Domain\LocalServer$' is not a valid user
- Previous by thread: Reporting Services RSExecRole
- Next by thread: Audit log that SA cannot modify
- Index(es):
Relevant Pages
|
|
