[Azure DB Create Login User] Create individual login accounts for Azure Databases #tags:sql,azure

azure_create_user.sql

-- in master (note, you need user to have access to master for proper login/testing)
create login [XXXX] with password = 'YYYYY';
create user [XXXX] from login [XXXX];

-- if you want the user to be able to create databases and logins
exec sp_addRoleMember 'dbmanager', 'XXXX';
exec sp_addRoleMember 'loginmanager', 'XXXX';

-- in each individual database, to grant dbo
create user [XXXX] from login [XXXX];
exec sp_addRoleMember 'db_owner', 'XXXX';
exec sp_addRoleMember 'db_datareader', 'XXXX';
exec sp_addRoleMember 'db_datawriter', 'XXXX';