December 1, 2004 at 1:41 am
How can I change the relationship in users of database between 'dbo' user and login Name.
I tried to do it by procedure:
EXEC sp_change_users_login 'Update_One', 'dbo', 'domain\username'
But I get error message : 'dbo' is a forbidden value for the login name parameter in this procedure.
The owner of the database is 'domain\username'
December 1, 2004 at 1:57 am
exec sp_addalias 'domain\username' , 'dbo'
These days the correct method is to make your user a member of the db_owner role.
The downside (and I use the term loosely) is that they must always qualify the objects that they create with the dbo owner.
December 1, 2004 at 3:08 am
Thank you, David, for guick reply. Unfortunately, you idea doesn't give me desired result. I need to receive in
Enterprise manager in Users :
in field 'Name' - dbo
in field 'Login Name' - domain\username'
Now in field 'Login Name' - sa
December 1, 2004 at 3:08 am
Thank you, David, for guick reply. Unfortunately, you idea doesn't give me desired result. I need to receive in
Enterprise manager in Users :
in field 'Name' - dbo
in field 'Login Name' - domain\username'
Now in field 'Login Name' - sa
December 1, 2004 at 3:23 am
try exec sp_changedbowner 'domain\user'
The thing with sp_addalias is that many logins can be aliased to one user.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply