Create user in Azure hosted SQL

Login to SQL Management Studio as the Azure defined SQL Admin

Change the items in red to those that you require.

In the Master Database
CREATE LOGIN username WITH password='password';

CREATE USER username FROM LOGIN username;

In the User Database.
CREATE USER username FROM LOGIN username;
EXEC sp_addrolemember N'db_owner', N'username'

For Read-only

CREATE USER username FROM LOGIN username;

EXEC sp_addrolemember N'db_datareader', N'username'