re-associate "dbo" user with "sa" login

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John A Grandy - 27 Jul 2006 19:15 GMT

Once "dbo" user on a particular db has been associated with a specific login
( "Login1") , how to re-associate it with its default login ( "sa" ) ?

My ultimate goal is to add user "User1" to this db and associate it with
login "Login1" . but to do that apparently I need to de-associate "Login1"
login from "dbo" user.

Reply to this Message

Sue Hoegemeier - 27 Jul 2006 23:18 GMT

It sounds like the user is the database owner. You can
change the owner to sa by executing the following in the
database:
exec sp_changedbowner 'sa'

-Sue

>Once "dbo" user on a particular db has been associated with a specific login
>( "Login1") , how to re-associate it with its default login ( "sa" ) ?
>
>My ultimate goal is to add user "User1" to this db and associate it with
>login "Login1" . but to do that apparently I need to de-associate "Login1"
>login from "dbo" user.

Reply to this Message