I am working on database project which is a .sql project in Visual Studio.I am creating user like this:
CREATE USER [MyUser] WITHOUT LOGIN;
ALTER ROLE [db_datareader] ADD MEMBER [MyUser]
ALTER ROLE [db_datawriter] ADD MEMBER [MyUser]
ALTER ROLE [db_executor] ADD MEMBER [MyUser]
I built dacpack in VSTS Build and deployed it to Azure in VSTS Release.
How do I setup the continuous deployment so that it will create user with password? Can anyone help me with this.