
use master; create login [NTSFDSQL01\alex.castillo] from windows with default_database=P21;
use master; create login [NTSFDSQL01\alexb] from windows with default_database=P21;
use master; create login [NTSFDSQL01\amy.bevis] from windows with default_database=P21;
use master; create login [NTSFDSQL01\amyw] from windows with default_database=P21;
use master; create login [NTSFDSQL01\andyd] from windows with default_database=P21;
use master; create login [NTSFDSQL01\aprild] from windows with default_database=P21;
use master; create login [NTSFDSQL01\barbc] from windows with default_database=P21;
use master; create login [NTSFDSQL01\billg] from windows with default_database=P21;
use master; create login [NTSFDSQL01\brendac] from windows with default_database=P21;
use master; create login [NTSFDSQL01\bryana] from windows with default_database=P21;
use master; create login [NTSFDSQL01\burinv2] from windows with default_database=P21;
use master; create login [NTSFDSQL01\burpkg1] from windows with default_database=P21;
use master; create login [NTSFDSQL01\chrisw] from windows with default_database=P21;
use master; create login [NTSFDSQL01\craigb] from windows with default_database=P21;
use master; create login [NTSFDSQL01\damiant] from windows with default_database=P21;
use master; create login [NTSFDSQL01\danc] from windows with default_database=P21;
use master; create login [NTSFDSQL01\dawn.tageson] from windows with default_database=P21;
use master; create login [NTSFDSQL01\deanc] from windows with default_database=P21;
use master; create login [NTSFDSQL01\deniser] from windows with default_database=P21;
use master; create login [NTSFDSQL01\desiree.mills] from windows with default_database=P21;
use master; create login [NTSFDSQL01\dianeh] from windows with default_database=P21;
use master; create login [NTSFDSQL01\Eddie.kubacki] from windows with default_database=P21;
use master; create login [NTSFDSQL01\ericw] from windows with default_database=P21;
use master; create login [NTSFDSQL01\fredr] from windows with default_database=P21;
use master; create login [NTSFDSQL01\garyc] from windows with default_database=P21;
use master; create login [NTSFDSQL01\heathers] from windows with default_database=P21;
use master; create login [NTSFDSQL01\Jake.Schloegl] from windows with default_database=P21;
use master; create login [NTSFDSQL01\jasons] from windows with default_database=P21;
use master; create login [NTSFDSQL01\jay.sprague] from windows with default_database=P21;
use master; create login [NTSFDSQL01\jeremyc] from windows with default_database=P21;
use master; create login [NTSFDSQL01\jessicat] from windows with default_database=P21;
use master; create login [NTSFDSQL01\joeg] from windows with default_database=P21;
use master; create login [NTSFDSQL01\johns] from windows with default_database=P21;
use master; create login [NTSFDSQL01\kenr] from windows with default_database=P21;
use master; create login [NTSFDSQL01\kevin.weathers] from windows with default_database=P21;
use master; create login [NTSFDSQL01\kim.smith] from windows with default_database=P21;
use master; create login [NTSFDSQL01\kimg] from windows with default_database=P21;
use master; create login [NTSFDSQL01\lorim] from windows with default_database=P21;
use master; create login [NTSFDSQL01\mariew] from windows with default_database=P21;
use master; create login [NTSFDSQL01\markb] from windows with default_database=P21;
use master; create login [NTSFDSQL01\marlened] from windows with default_database=P21;
use master; create login [NTSFDSQL01\martele] from windows with default_database=P21;
use master; create login [NTSFDSQL01\mattb] from windows with default_database=P21;
use master; create login [NTSFDSQL01\matts] from windows with default_database=P21;
use master; create login [NTSFDSQL01\mattt] from windows with default_database=P21;
use master; create login [NTSFDSQL01\michaels] from windows with default_database=P21;
use master; create login [NTSFDSQL01\noahs] from windows with default_database=P21;
use master; create login [NTSFDSQL01\nutech] from windows with default_database=P21;
use master; create login [NTSFDSQL01\parker.norton] from windows with default_database=P21;
use master; create login [NTSFDSQL01\Robb] from windows with default_database=P21;
use master; create login [NTSFDSQL01\Robk] from windows with default_database=P21;
use master; create login [NTSFDSQL01\sallyc] from windows with default_database=P21;
use master; create login [NTSFDSQL01\schellenk] from windows with default_database=P21;
use master; create login [NTSFDSQL01\scottd] from windows with default_database=P21;
use master; create login [NTSFDSQL01\sharicer] from windows with default_database=P21;
use master; create login [NTSFDSQL01\sheree.smith] from windows with default_database=P21;
use master; create login [NTSFDSQL01\stevens] from windows with default_database=P21;
use master; create login [NTSFDSQL01\taylorj] from windows with default_database=P21;
use master; create login [NTSFDSQL01\timb] from windows with default_database=P21;
use master; create login [NTSFDSQL01\tina.schriner] from windows with default_database=P21;
GO

use P21; create user [NTSFDSQL01\alex.castillo] from login [NTSFDSQL01\alex.castillo];
use P21; create user [NTSFDSQL01\alexb] from login [NTSFDSQL01\alexb];
use P21; create user [NTSFDSQL01\amy.bevis] from login [NTSFDSQL01\amy.bevis];
use P21; create user [NTSFDSQL01\amyw] from login [NTSFDSQL01\amyw];
use P21; create user [NTSFDSQL01\andyd] from login [NTSFDSQL01\andyd];
use P21; create user [NTSFDSQL01\aprild] from login [NTSFDSQL01\aprild];
use P21; create user [NTSFDSQL01\barbc] from login [NTSFDSQL01\barbc];
use P21; create user [NTSFDSQL01\billg] from login [NTSFDSQL01\billg];
use P21; create user [NTSFDSQL01\brendac] from login [NTSFDSQL01\brendac];
use P21; create user [NTSFDSQL01\bryana] from login [NTSFDSQL01\bryana];
use P21; create user [NTSFDSQL01\burinv2] from login [NTSFDSQL01\burinv2];
use P21; create user [NTSFDSQL01\burpkg1] from login [NTSFDSQL01\burpkg1];
use P21; create user [NTSFDSQL01\chrisw] from login [NTSFDSQL01\chrisw];
use P21; create user [NTSFDSQL01\craigb] from login [NTSFDSQL01\craigb];
use P21; create user [NTSFDSQL01\damiant] from login [NTSFDSQL01\damiant];
use P21; create user [NTSFDSQL01\danc] from login [NTSFDSQL01\danc];
use P21; create user [NTSFDSQL01\dawn.tageson] from login [NTSFDSQL01\dawn.tageson];
use P21; create user [NTSFDSQL01\deanc] from login [NTSFDSQL01\deanc];
use P21; create user [NTSFDSQL01\deniser] from login [NTSFDSQL01\deniser];
use P21; create user [NTSFDSQL01\desiree.mills] from login [NTSFDSQL01\desiree.mills];
use P21; create user [NTSFDSQL01\dianeh] from login [NTSFDSQL01\dianeh];
use P21; create user [NTSFDSQL01\Eddie.kubacki] from login [NTSFDSQL01\Eddie.kubacki];
use P21; create user [NTSFDSQL01\ericw] from login [NTSFDSQL01\ericw];
use P21; create user [NTSFDSQL01\fredr] from login [NTSFDSQL01\fredr];
use P21; create user [NTSFDSQL01\garyc] from login [NTSFDSQL01\garyc];
use P21; create user [NTSFDSQL01\heathers] from login [NTSFDSQL01\heathers];
use P21; create user [NTSFDSQL01\Jake.Schloegl] from login [NTSFDSQL01\Jake.Schloegl];
use P21; create user [NTSFDSQL01\jasons] from login [NTSFDSQL01\jasons];
use P21; create user [NTSFDSQL01\jay.sprague] from login [NTSFDSQL01\jay.sprague];
use P21; create user [NTSFDSQL01\jeremyc] from login [NTSFDSQL01\jeremyc];
use P21; create user [NTSFDSQL01\jessicat] from login [NTSFDSQL01\jessicat];
use P21; create user [NTSFDSQL01\joeg] from login [NTSFDSQL01\joeg];
use P21; create user [NTSFDSQL01\johns] from login [NTSFDSQL01\johns];
use P21; create user [NTSFDSQL01\kenr] from login [NTSFDSQL01\kenr];
use MSBS; create user [NTSFDSQL01\kenr] from login [NTSFDSQL01\kenr];
use P21; create user [NTSFDSQL01\kevin.weathers] from login [NTSFDSQL01\kevin.weathers];
use P21; create user [NTSFDSQL01\kim.smith] from login [NTSFDSQL01\kim.smith];
use P21; create user [NTSFDSQL01\kimg] from login [NTSFDSQL01\kimg];
use P21; create user [NTSFDSQL01\lorim] from login [NTSFDSQL01\lorim];
use P21; create user [NTSFDSQL01\mariew] from login [NTSFDSQL01\mariew];
use P21; create user [NTSFDSQL01\markb] from login [NTSFDSQL01\markb];
use P21; create user [NTSFDSQL01\marlened] from login [NTSFDSQL01\marlened];
use P21; create user [NTSFDSQL01\martele] from login [NTSFDSQL01\martele];
use P21; create user [NTSFDSQL01\mattb] from login [NTSFDSQL01\mattb];
use P21; create user [NTSFDSQL01\matts] from login [NTSFDSQL01\matts];
use P21; create user [NTSFDSQL01\mattt] from login [NTSFDSQL01\mattt];
use P21; create user [NTSFDSQL01\michaels] from login [NTSFDSQL01\michaels];
use P21; create user [NTSFDSQL01\noahs] from login [NTSFDSQL01\noahs];
use P21; create user [NTSFDSQL01\nutech] from login [NTSFDSQL01\nutech];
use P21; create user [NTSFDSQL01\parker.norton] from login [NTSFDSQL01\parker.norton];
use P21; create user [NTSFDSQL01\Robb] from login [NTSFDSQL01\Robb];
use P21; create user [NTSFDSQL01\Robk] from login [NTSFDSQL01\Robk];
use P21; create user [NTSFDSQL01\sallyc] from login [NTSFDSQL01\sallyc];
use P21; create user [NTSFDSQL01\schellenk] from login [NTSFDSQL01\schellenk];
use P21; create user [NTSFDSQL01\scottd] from login [NTSFDSQL01\scottd];
use P21; create user [NTSFDSQL01\sharicer] from login [NTSFDSQL01\sharicer];
use P21; create user [NTSFDSQL01\sheree.smith] from login [NTSFDSQL01\sheree.smith];
use P21; create user [NTSFDSQL01\stevens] from login [NTSFDSQL01\stevens];
use P21; create user [NTSFDSQL01\taylorj] from login [NTSFDSQL01\taylorj];
use P21; create user [NTSFDSQL01\timb] from login [NTSFDSQL01\timb];
use P21; create user [NTSFDSQL01\tina.schriner] from login [NTSFDSQL01\tina.schriner];
use MSBS; create user [NTSFDSQL01\tina.schriner] from login [NTSFDSQL01\tina.schriner];
GO

EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\alex.castillo];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\alexb];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\amy.bevis];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\amyw];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\andyd];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\aprild];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\barbc];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\billg];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\brendac];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\bryana];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\burinv2];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\burpkg1];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\chrisw];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\craigb];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\damiant];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\danc];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\dawn.tageson];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\deanc];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\deniser];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\desiree.mills];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\dianeh];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\Eddie.kubacki];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\ericw];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\fredr];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\garyc];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\heathers];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\Jake.Schloegl];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\jasons];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\jay.sprague];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\jeremyc];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\jessicat];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\joeg];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\johns];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\kenr];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\kevin.weathers];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\kim.smith];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\kimg];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\lorim];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\mariew];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\markb];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\marlened];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\martele];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\mattb];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\matts];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\mattt];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\michaels];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\noahs];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\nutech];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\parker.norton];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\Robb];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\Robk];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\sallyc];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\schellenk];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\scottd];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\sharicer];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\sheree.smith];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\stevens];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\taylorj];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\timb];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\tina.schriner];
GO
