Logins

USE [master];
GO
CREATE LOGIN app_owner_dev
  WITH   PASSWORD         = 'yyyyyy'
       , DEFAULT_DATABASE = [db_name_dev]
       , CHECK_EXPIRATION = OFF
       , CHECK_POLICY     = OFF
;

CREATE LOGIN app_user_dev
  WITH   PASSWORD         = 'aaaaaa'
       , DEFAULT_DATABASE = [db_name_dev]
       , CHECK_EXPIRATION = OFF
       , CHECK_POLICY     = OFF
;

CREATE LOGIN app_reader_dev
  WITH   PASSWORD         = 'qqqqqq'
       , DEFAULT_DATABASE = [db_name_dev]
       , CHECK_EXPIRATION = OFF
       , CHECK_POLICY     = OFF
;

CREATE LOGIN app_dba_dev
  WITH   PASSWORD         = 'wwwwww'
       , DEFAULT_DATABASE = [db_name_dev]
       , CHECK_EXPIRATION = OFF
       , CHECK_POLICY     = OFF
;

GO

-- Vorher
USE [db_name_dev];
GO
EXEC sp_change_users_login 'Report'
GO

USE [db_name_dev];
GO
ALTER USER app_dba     WITH LOGIN=[app_dba_dev]    ;
ALTER USER app_owner   WITH LOGIN=[app_owner_dev]  ;
ALTER USER app_reader  WITH LOGIN=[app_reader_dev] ;
ALTER USER app_user    WITH LOGIN=[app_user_dev]   ;
GO

-- Nachher
USE [db_name_dev];
GO
EXEC sp_change_users_login 'Report'
GO

USE [db_name_dev];
EXEC dbo.sp_changedbowner @loginame = N'???', @map = false
GO