Creating SQL Azure login for single database
Connect to master database and do the following:

CREATE LOGIN YourNewUser WITH PASSWORD = '&amp;lt;strong password here&amp;gt;';


Connect directly to database that the new user should own:

CREATE USER YourNewUser FOR LOGIN YourNewUser;

EXEC sp_addrolemember 'db_owner', 'YourNewUser';