SQL Azure: how to change dbo user with new name

Question

In SQL AzureI want to assign a username to a [login1]user [dbo].

Now I logged in with the account [login1]and tried this:

ALTER USER [dbo] WITH LOGIN = [login1]

But he says:

Unable to change user 'dbo'.

I also tried this:

ALTER AUTHORIZATION ON SCHEMA::[dbo] TO [login1]

But he says:

Cannot find user 'login1' because he is not there or you do not have permission.

I can create a new type table [dbo].[MyTable], but I do not see it in the list of tables, even if it exists.

Any ideas?

Answer 1

[dbo] [login1], [login1] db_owner. :

-- in master db
CREATE LOGIN [login1] WITH PASSWORD = '{Some Password}'
CREATE USER [login1] FOR LOGIN [login1]

-- in user db
CREATE USER [login1] FOR LOGIN [login1]
ALTER ROLE [db_owner] ADD MEMBER [login1]

Answer 2

1. Login1 ( ) 2. db exec script:

sp_changedbowner 'Login1'

, [dbo] [login1]