Create SQL Contained User

create-contained-user.sql

DECLARE @UName varchar(50)
DECLARE @PW varchar(50)
DECLARE @SQL varchar(400)
SET @UName='connection-string-user'
SET @PW='password'
SET @SQL='DROP USER IF EXISTS ['+@UName+'];'+
' CREATE USER ['+@UName+'] WITH PASSWORD = '''+@PW+''', DEFAULT_SCHEMA = dbo;'+
' GRANT VIEW DEFINITION TO ['+@UName+'];'+
' EXEC sp_addrolemember ''db_owner'', '''+@UName+''';'+
' ALTER ROLE db_owner ADD MEMBER ['+@UName+'];'
--SELECT @SQL
EXEC (@SQL);