USE [P21]
GO

DECLARE @newUser varchar(30);
DECLARE @cmd varchar(200);


select DB_NAME() [database], name as [user_name], type_desc,default_schema_name,create_date,modify_date,
       'DROP USER [' + name + ']'
from sys.database_principals 
where type in ('G','S','U') 
and authentication_type<>2 -- Use this filter only if you are running on SQL Server 2012 and major versions and you have "contained databases"
and [sid] not in ( select [sid] from sys.server_principals where type in ('G','S','U') ) 
and name not in ('dbo','guest','INFORMATION_SCHEMA','sys','MS_DataCollectorInternalUser')
and name like 'MIDSTATESBOLT\%'
and type_desc = 'WINDOWS_USER'

DROP USER [MIDSTATESBOLT\Kevin.Weathers]
DROP USER [MIDSTATESBOLT\amyw]
DROP USER [MIDSTATESBOLT\andyb]
DROP USER [MIDSTATESBOLT\Bernieb]
DROP USER [MIDSTATESBOLT\lanctr1]
DROP USER [MIDSTATESBOLT\billc]
DROP USER [MIDSTATESBOLT\billg]
DROP USER [MIDSTATESBOLT\bradk]
DROP USER [MIDSTATESBOLT\brendac]
DROP USER [MIDSTATESBOLT\barbc]
DROP USER [MIDSTATESBOLT\lanshp]
DROP USER [MIDSTATESBOLT\AARHaynes.ScanGun]
DROP USER [MIDSTATESBOLT\charless]
DROP USER [MIDSTATESBOLT\chrisf]
DROP USER [MIDSTATESBOLT\chrisw]
DROP USER [MIDSTATESBOLT\dalec]
DROP USER [MIDSTATESBOLT\DavidS]
DROP USER [MIDSTATESBOLT\AndyD]
DROP USER [MIDSTATESBOLT\garyp]
DROP USER [MIDSTATESBOLT\burpkg1]
DROP USER [MIDSTATESBOLT\Catherine.Jobe]
DROP USER [MIDSTATESBOLT\dougs]
DROP USER [MIDSTATESBOLT\ericw]
DROP USER [MIDSTATESBOLT\garyc]
DROP USER [MIDSTATESBOLT\Cindy.Klepoch]
DROP USER [MIDSTATESBOLT\jessicat]
DROP USER [MIDSTATESBOLT\jimb]
DROP USER [MIDSTATESBOLT\scottk]
DROP USER [MIDSTATESBOLT\bryana]
DROP USER [MIDSTATESBOLT\Sheree.Smith]
DROP USER [MIDSTATESBOLT\johnm]
DROP USER [MIDSTATESBOLT\timb]
DROP USER [MIDSTATESBOLT\Dawn.Tageson]
DROP USER [MIDSTATESBOLT\kenh]
DROP USER [MIDSTATESBOLT\Retrax.ScanGun]
DROP USER [MIDSTATESBOLT\Eric.Galat]
DROP USER [MIDSTATESBOLT\kimg]
DROP USER [MIDSTATESBOLT\Georgia.Frank]
DROP USER [MIDSTATESBOLT\Julie.Wickson]
DROP USER [MIDSTATESBOLT\lorih]
DROP USER [MIDSTATESBOLT\burinv2]
DROP USER [MIDSTATESBOLT\marcs]
DROP USER [MIDSTATESBOLT\matts]
DROP USER [MIDSTATESBOLT\EQSystems]
DROP USER [MIDSTATESBOLT\mattt]
DROP USER [MIDSTATESBOLT\Jay.Sprague]
DROP USER [MIDSTATESBOLT\METALWORKS]
DROP USER [MIDSTATESBOLT\michellem]
DROP USER [MIDSTATESBOLT\madisong]
DROP USER [MIDSTATESBOLT\Desiree.Mills]
DROP USER [MIDSTATESBOLT\Brennan.Bass]
DROP USER [MIDSTATESBOLT\Eddie.Kubacki]
DROP USER [MIDSTATESBOLT\Tina.Schriner]
DROP USER [MIDSTATESBOLT\pauld]
DROP USER [MIDSTATESBOLT\Jamie.Ullmer]
DROP USER [MIDSTATESBOLT\Matt.Yakich]
DROP USER [MIDSTATESBOLT\rickr]
DROP USER [MIDSTATESBOLT\robb]
DROP USER [MIDSTATESBOLT\robertf]
DROP USER [MIDSTATESBOLT\ShariceR]
DROP USER [MIDSTATESBOLT\Anthony.Bartolone]
DROP USER [MIDSTATESBOLT\robk]
DROP USER [MIDSTATESBOLT\RochelleV]
DROP USER [MIDSTATESBOLT\Jake.Schloegl]
DROP USER [MIDSTATESBOLT\scotts]
DROP USER [MIDSTATESBOLT\Parker.Norton]
DROP USER [MIDSTATESBOLT\Michael.Wescoat]
DROP USER [MIDSTATESBOLT\GerardoC]
DROP USER [MIDSTATESBOLT\LaceyP]
DROP USER [MIDSTATESBOLT\taylorj]
DROP USER [MIDSTATESBOLT\Lance.Keeley]
DROP USER [MIDSTATESBOLT\toddo]
DROP USER [MIDSTATESBOLT\TRENTH]
DROP USER [MIDSTATESBOLT\EQSystems.ScanGun]
DROP USER [MIDSTATESBOLT\Steven.Skopek]
DROP USER [MIDSTATESBOLT\Matt.Hewitt]
DROP USER [MIDSTATESBOLT\fltrec2]
DROP USER [MIDSTATESBOLT\fltshp1]
DROP USER [MIDSTATESBOLT\fltshp2]
DROP USER [MIDSTATESBOLT\fltrec1]
DROP USER [MIDSTATESBOLT\sagctr1]
DROP USER [MIDSTATESBOLT\sagrec]
DROP USER [MIDSTATESBOLT\sagshp]
DROP USER [MIDSTATESBOLT\stactr1]
DROP USER [MIDSTATESBOLT\lanrec]
DROP USER [MIDSTATESBOLT\stactr2]
DROP USER [MIDSTATESBOLT\gayshp]
DROP USER [MIDSTATESBOLT\gayrec]
DROP USER [MIDSTATESBOLT\sherec]
DROP USER [MIDSTATESBOLT\nilctr]
DROP USER [MIDSTATESBOLT\nilshp]
DROP USER [MIDSTATESBOLT\nilrec]
DROP USER [MIDSTATESBOLT\jimk]
DROP USER [MIDSTATESBOLT\morbark]
DROP USER [MIDSTATESBOLT\Kelly.Smith]
DROP USER [MIDSTATESBOLT\TRAINING]
DROP USER [MIDSTATESBOLT\FLTCTR1]
DROP USER [MIDSTATESBOLT\FLTCTR2]
DROP USER [MIDSTATESBOLT\AARHAYNES]
DROP USER [MIDSTATESBOLT\aar6th]
DROP USER [midstatesbolt\sagctr2]
DROP USER [MIDSTATESBOLT\fltctr3]
DROP USER [MIDSTATESBOLT\Eva.Reimer]
DROP USER [MIDSTATESBOLT\Vermeer]
DROP USER [MIDSTATESBOLT\Elkwhse]
DROP USER [MIDSTATESBOLT\BurPkg6]
DROP USER [MIDSTATESBOLT\BRIAN.FESSLER]
DROP USER [MIDSTATESBOLT\Vermeer.ScanGun]
DROP USER [MIDSTATESBOLT\BakMO.ScanGun]
DROP USER [MIDSTATESBOLT\msbsrptuser]
DROP USER [MIDSTATESBOLT\Karen.Hlywa]
DROP USER [MIDSTATESBOLT\jeremyc]
DROP USER [MIDSTATESBOLT\LoriM]
DROP USER [MIDSTATESBOLT\pattye]
DROP USER [MIDSTATESBOLT\annep]
DROP USER [MIDSTATESBOLT\reports]
DROP USER [MIDSTATESBOLT\michaelg]
DROP USER [MIDSTATESBOLT\davidg]
DROP USER [MIDSTATESBOLT\MichaelS]
DROP USER [MIDSTATESBOLT\lanctr2]
DROP USER [MIDSTATESBOLT\DanS]
DROP USER [MIDSTATESBOLT\RogerW]
DROP USER [MIDSTATESBOLT\SallyC]
DROP USER [MIDSTATESBOLT\sheord1]
DROP USER [MIDSTATESBOLT\WayneG]
DROP USER [MIDSTATESBOLT\Stashp]
DROP USER [MIDSTATESBOLT\heathers]
DROP USER [MIDSTATESBOLT\JohnS]
DROP USER [MIDSTATESBOLT\tmican]
DROP USER [MIDSTATESBOLT\starec1]
DROP USER [MIDSTATESBOLT\sarahk]
DROP USER [MIDSTATESBOLT\CraigB]
DROP USER [MIDSTATESBOLT\KenR]
DROP USER [MIDSTATESBOLT\DanC]
DROP USER [MIDSTATESBOLT\joeg]
DROP USER [MIDSTATESBOLT\norshp1]
DROP USER [MIDSTATESBOLT\nutech]
DROP USER [MIDSTATESBOLT\mattb]
DROP USER [MIDSTATESBOLT\lanord]
DROP USER [MIDSTATESBOLT\norrec1]
DROP USER [MIDSTATESBOLT\joev]
DROP USER [MIDSTATESBOLT\nfabtx]
DROP USER [MIDSTATESBOLT\tamic]
DROP USER [MIDSTATESBOLT\kenk]
DROP USER [MIDSTATESBOLT\GregB]
DROP USER [MIDSTATESBOLT\pershp]
DROP USER [MIDSTATESBOLT\perctr]
DROP USER [MIDSTATESBOLT\perrec]
DROP USER [MIDSTATESBOLT\debrah]
DROP USER [MIDSTATESBOLT\burord1]
DROP USER [MIDSTATESBOLT\wesleys]
DROP USER [MIDSTATESBOLT\borroughs]
DROP USER [MIDSTATESBOLT\vickiej]
DROP USER [MIDSTATESBOLT\nilrec2]
DROP USER [MIDSTATESBOLT\perrec2]
DROP USER [MIDSTATESBOLT\gayctr1]
DROP USER [MIDSTATESBOLT\gayctr2]
DROP USER [MIDSTATESBOLT\bakmo]
DROP USER [MIDSTATESBOLT\martele]
DROP USER [MIDSTATESBOLT\burplat]
DROP USER [MIDSTATESBOLT\noahs]
DROP USER [MIDSTATESBOLT\shectr]
DROP USER [MIDSTATESBOLT\sheshp]
DROP USER [MIDSTATESBOLT\pattiek]
DROP USER [MIDSTATESBOLT\AndrewR]
DROP USER [MIDSTATESBOLT\StephanieP]
DROP USER [MIDSTATESBOLT\deanc]
DROP USER [MIDSTATESBOLT\retrax]
DROP USER [MIDSTATESBOLT\alexb]
DROP USER [MIDSTATESBOLT\burinv1]
DROP USER [MIDSTATESBOLT\stainv1]
DROP USER [MIDSTATESBOLT\perinv1]
DROP USER [MIDSTATESBOLT\gasfired]
DROP USER [MIDSTATESBOLT\extang]
DROP USER [MIDSTATESBOLT\itdept]
DROP USER [MIDSTATESBOLT\burpkgsup]
DROP USER [MIDSTATESBOLT\burord2]
DROP USER [MIDSTATESBOLT\FredR]
DROP USER [MIDSTATESBOLT\alexm]
DROP USER [MIDSTATESBOLT\burpkg2]
DROP USER [MIDSTATESBOLT\Administrator]
DROP USER [MIDSTATESBOLT\saginv1]
DROP USER [MIDSTATESBOLT\wwms1]
DROP USER [MIDSTATESBOLT\wwms2]
DROP USER [MIDSTATESBOLT\tannerw]
DROP USER [MIDSTATESBOLT\chadf]
DROP USER [MIDSTATESBOLT\epicorP21MWuser]
DROP USER [MIDSTATESBOLT\laninv1]
DROP USER [MIDSTATESBOLT\gayinv1]
DROP USER [MIDSTATESBOLT\norinv1]
DROP USER [MIDSTATESBOLT\sheinv1]
DROP USER [MIDSTATESBOLT\nilinv1]
DROP USER [MIDSTATESBOLT\KristopherB]
DROP USER [MIDSTATESBOLT\KurtB]
DROP USER [MIDSTATESBOLT\DennisF]
DROP USER [MIDSTATESBOLT\MicheleG]
DROP USER [MIDSTATESBOLT\LachellH]
DROP USER [MIDSTATESBOLT\MichaelK]
DROP USER [MIDSTATESBOLT\RyanK]
DROP USER [MIDSTATESBOLT\BradleyK]
DROP USER [MIDSTATESBOLT\KarenM]
DROP USER [MIDSTATESBOLT\AndreaB]
DROP USER [MIDSTATESBOLT\ShakieaP]
DROP USER [MIDSTATESBOLT\TrishaP]
DROP USER [MIDSTATESBOLT\DustynR]
DROP USER [MIDSTATESBOLT\EmilyS]
DROP USER [MIDSTATESBOLT\ShannonS]
DROP USER [MIDSTATESBOLT\JamesS]
DROP USER [MIDSTATESBOLT\WilliamS]
DROP USER [MIDSTATESBOLT\DamianT]
DROP USER [MIDSTATESBOLT\JohnW]
DROP USER [MIDSTATESBOLT\GarrettW]
DROP USER [MIDSTATESBOLT\HermanW]
DROP USER [MIDSTATESBOLT\JesseY]
DROP USER [MIDSTATESBOLT\ShereseA]
DROP USER [MIDSTATESBOLT\MichelleB]
DROP USER [MIDSTATESBOLT\ChantellB]
DROP USER [MIDSTATESBOLT\ZandraC]
DROP USER [MIDSTATESBOLT\LucretiaC]
DROP USER [MIDSTATESBOLT\LauraC]
DROP USER [MIDSTATESBOLT\InezH]
DROP USER [MIDSTATESBOLT\CharlesJ]
DROP USER [MIDSTATESBOLT\AndreaD]
DROP USER [MIDSTATESBOLT\JessicaM]
DROP USER [MIDSTATESBOLT\TiaraO]
DROP USER [MIDSTATESBOLT\KeishaP]
DROP USER [MIDSTATESBOLT\CurtC]
DROP USER [MIDSTATESBOLT\NathanielG]
DROP USER [MIDSTATESBOLT\KristopherH]
DROP USER [MIDSTATESBOLT\ZacharyP]
DROP USER [MIDSTATESBOLT\NedW]
DROP USER [MIDSTATESBOLT\Jill-AnnaF]
DROP USER [MIDSTATESBOLT\AlbertJ]
DROP USER [MIDSTATESBOLT\NicholasP]
DROP USER [MIDSTATESBOLT\AdamR]
DROP USER [MIDSTATESBOLT\RobertR]
DROP USER [MIDSTATESBOLT\WayneB]
DROP USER [MIDSTATESBOLT\RobertH]
DROP USER [MIDSTATESBOLT\DianeH]
DROP USER [MIDSTATESBOLT\ChristopherL]
DROP USER [MIDSTATESBOLT\NicholasM]
DROP USER [MIDSTATESBOLT\CollinM]
DROP USER [MIDSTATESBOLT\ChristoferS]
DROP USER [MIDSTATESBOLT\ElaineS]
DROP USER [MIDSTATESBOLT\JoeW]
DROP USER [MIDSTATESBOLT\JohnZ]
DROP USER [MIDSTATESBOLT\MikaylaC]
DROP USER [MIDSTATESBOLT\ArriannaC]
DROP USER [MIDSTATESBOLT\MichaelE]
DROP USER [MIDSTATESBOLT\EstevanG]
DROP USER [MIDSTATESBOLT\RickyH]
DROP USER [MIDSTATESBOLT\KarlaJ]
DROP USER [MIDSTATESBOLT\GarrettWJr]
DROP USER [MIDSTATESBOLT\JamesT]
DROP USER [MIDSTATESBOLT\RobertB]
DROP USER [MIDSTATESBOLT\CrystalB]
DROP USER [MIDSTATESBOLT\PeterC]
DROP USER [MIDSTATESBOLT\JeffreyM]
DROP USER [MIDSTATESBOLT\MarvinP]
DROP USER [MIDSTATESBOLT\DannyS]
DROP USER [MIDSTATESBOLT\TerriS]
DROP USER [MIDSTATESBOLT\VictorineW]
DROP USER [MIDSTATESBOLT\JeffreyW]
DROP USER [MIDSTATESBOLT\MarkB]
DROP USER [MIDSTATESBOLT\ChaseG]
DROP USER [MIDSTATESBOLT\DawnL]
DROP USER [MIDSTATESBOLT\JasonP]
DROP USER [MIDSTATESBOLT\MelvinT]
DROP USER [MIDSTATESBOLT\LindaV]
DROP USER [MIDSTATESBOLT\JamesSor]
DROP USER [MIDSTATESBOLT\AprilD]
DROP USER [MIDSTATESBOLT\JohnH]
DROP USER [MIDSTATESBOLT\JessicaJ]
DROP USER [MIDSTATESBOLT\KellyM]
DROP USER [MIDSTATESBOLT\SethS]
DROP USER [MIDSTATESBOLT\burwwms1]
DROP USER [MIDSTATESBOLT\burwwms2]
DROP USER [MIDSTATESBOLT\burwwms3]
DROP USER [MIDSTATESBOLT\burwwms4]
DROP USER [MIDSTATESBOLT\burwwms5]
DROP USER [MIDSTATESBOLT\gaywwms1]
DROP USER [MIDSTATESBOLT\gaywwms2]
DROP USER [MIDSTATESBOLT\gaywwms3]
DROP USER [MIDSTATESBOLT\gaywwms4]
DROP USER [MIDSTATESBOLT\gaywwms5]
DROP USER [MIDSTATESBOLT\lanwwms1]
DROP USER [MIDSTATESBOLT\lanwwms2]
DROP USER [MIDSTATESBOLT\lanwwms3]
DROP USER [MIDSTATESBOLT\lanwwms4]
DROP USER [MIDSTATESBOLT\lanwwms5]
DROP USER [MIDSTATESBOLT\nilwwms1]
DROP USER [MIDSTATESBOLT\nilwwms2]
DROP USER [MIDSTATESBOLT\nilwwms3]
DROP USER [MIDSTATESBOLT\nilwwms4]
DROP USER [MIDSTATESBOLT\nilwwms5]
DROP USER [MIDSTATESBOLT\norwwms1]
DROP USER [MIDSTATESBOLT\norwwms2]
DROP USER [MIDSTATESBOLT\norwwms3]
DROP USER [MIDSTATESBOLT\norwwms4]
DROP USER [MIDSTATESBOLT\norwwms5]
DROP USER [MIDSTATESBOLT\perwwms1]
DROP USER [MIDSTATESBOLT\perwwms2]
DROP USER [MIDSTATESBOLT\perwwms3]
DROP USER [MIDSTATESBOLT\perwwms4]
DROP USER [MIDSTATESBOLT\perwwms5]
DROP USER [MIDSTATESBOLT\sagwwms1]
DROP USER [MIDSTATESBOLT\sagwwms2]
DROP USER [MIDSTATESBOLT\sagwwms3]
DROP USER [MIDSTATESBOLT\sagwwms4]
DROP USER [MIDSTATESBOLT\sagwwms5]
DROP USER [MIDSTATESBOLT\shewwms1]
DROP USER [MIDSTATESBOLT\shewwms2]
DROP USER [MIDSTATESBOLT\shewwms3]
DROP USER [MIDSTATESBOLT\shewwms4]
DROP USER [MIDSTATESBOLT\shewwms5]
DROP USER [MIDSTATESBOLT\stawwms1]
DROP USER [MIDSTATESBOLT\stawwms2]
DROP USER [MIDSTATESBOLT\stawwms3]
DROP USER [MIDSTATESBOLT\stawwms4]
DROP USER [MIDSTATESBOLT\stawwms5]
DROP USER [MIDSTATESBOLT\ScottD]
DROP USER [MIDSTATESBOLT\JasonS]
DROP USER [MIDSTATESBOLT\WillemD]
DROP USER [MIDSTATESBOLT\CandishaBT]
DROP USER [MIDSTATESBOLT\KarenN]
DROP USER [MIDSTATESBOLT\LuisJ]
DROP USER [MIDSTATESBOLT\JamesD]
DROP USER [MIDSTATESBOLT\JulieW]
DROP USER [MIDSTATESBOLT\KristianR]
DROP USER [MIDSTATESBOLT\RamonaB]
DROP USER [MIDSTATESBOLT\BennettG]
DROP USER [MIDSTATESBOLT\PKGWWMS1]
DROP USER [MIDSTATESBOLT\PKGWWMS2]
DROP USER [MIDSTATESBOLT\MikeG]
DROP USER [MIDSTATESBOLT\SandraA]
DROP USER [MIDSTATESBOLT\BurPkgInv1]
DROP USER [MIDSTATESBOLT\BurPkgInv2]
DROP USER [MIDSTATESBOLT\PattersonK]
DROP USER [MIDSTATESBOLT\SharikaC]
DROP USER [MIDSTATESBOLT\cuesvan]
DROP USER [MIDSTATESBOLT\cues]
DROP USER [MIDSTATESBOLT\mariew]
DROP USER [MIDSTATESBOLT\BurPkgOrd1]
DROP USER [MIDSTATESBOLT\JerryA]
DROP USER [MIDSTATESBOLT\MikeC]
DROP USER [MIDSTATESBOLT\MartiH]
DROP USER [MIDSTATESBOLT\JustinT]
DROP USER [MIDSTATESBOLT\BurPkg4]
DROP USER [MIDSTATESBOLT\BurPkg5]
DROP USER [MIDSTATESBOLT\MichaelW]
DROP USER [MIDSTATESBOLT\burwwms6]
DROP USER [MIDSTATESBOLT\burwwms7]
DROP USER [MIDSTATESBOLT\burwwms8]
DROP USER [MIDSTATESBOLT\burwwms9]
DROP USER [MIDSTATESBOLT\burwwms10]
DROP USER [MIDSTATESBOLT\JeffS]
DROP USER [MIDSTATESBOLT\AllenW]
DROP USER [MIDSTATESBOLT\PaulR]
DROP USER [MIDSTATESBOLT\CharlesG]
DROP USER [MIDSTATESBOLT\ChloeW]
DROP USER [MIDSTATESBOLT\ChrisS]
DROP USER [MIDSTATESBOLT\BURWWMS11]
DROP USER [MIDSTATESBOLT\BURWWMS12]
DROP USER [MIDSTATESBOLT\BURWWMS13]
DROP USER [MIDSTATESBOLT\DanikaS]
DROP USER [MIDSTATESBOLT\StaOrd1]
DROP USER [MIDSTATESBOLT\MohamedB]
DROP USER [MIDSTATESBOLT\MarleneD]
DROP USER [MIDSTATESBOLT\EdwardC]
DROP USER [MIDSTATESBOLT\VickiW]
DROP USER [MIDSTATESBOLT\KevinK]
DROP USER [MIDSTATESBOLT\StevenS]
DROP USER [MIDSTATESBOLT\perctr2]
DROP USER [MIDSTATESBOLT\DougB]
DROP USER [MIDSTATESBOLT\AndreaR]
DROP USER [MIDSTATESBOLT\LeahL]
DROP USER [MIDSTATESBOLT\TerryM]
DROP USER [MIDSTATESBOLT\DavidC]
DROP USER [MIDSTATESBOLT\Elisa.Locke]
DROP USER [MIDSTATESBOLT\Jerry.Saraun]
DROP USER [MIDSTATESBOLT\KaisAIR]
DROP USER [MIDSTATESBOLT\Joe.Waldrop]
DROP USER [MIDSTATESBOLT\Mike.Watson]
DROP USER [MIDSTATESBOLT\James.Collier]
DROP USER [MIDSTATESBOLT\DanaH]
DROP USER [MIDSTATESBOLT\jayh]
DROP USER [MIDSTATESBOLT\Amy.Bevis]
DROP USER [MIDSTATESBOLT\Stephanie.VanDusen]
DROP USER [MIDSTATESBOLT\BernardetteG]
DROP USER [MIDSTATESBOLT\Jordan.Nickell]
DROP USER [MIDSTATESBOLT\Misty.OBriant]
DROP USER [MIDSTATESBOLT\Amanda.Jackson]
DROP USER [MIDSTATESBOLT\WaltG]
DROP USER [MIDSTATESBOLT\Glenn.Dennis]
DROP USER [MIDSTATESBOLT\Yahya.Mhoder]
DROP USER [MIDSTATESBOLT\LEILANI.ELIASON]
DROP USER [MIDSTATESBOLT\Todd.Szymkowicz]
DROP USER [MIDSTATESBOLT\Phelan.Brown]
DROP USER [MIDSTATESBOLT\KaisAIR.ScanGun]
DROP USER [MIDSTATESBOLT\GasFired.ScanGun]
DROP USER [MIDSTATESBOLT\EJ.ScanGun]
DROP USER [MIDSTATESBOLT\Jim.Bostic]
DROP USER [MIDSTATESBOLT\Monique.Springer]
DROP USER [MIDSTATESBOLT\uncomo]
DROP USER [MIDSTATESBOLT\Nicholas.Gonzalez]
DROP USER [MIDSTATESBOLT\burpkg3]
DROP USER [MIDSTATESBOLT\DeniseR]
DROP USER [MIDSTATESBOLT\Amanda.White]
DROP USER [MIDSTATESBOLT\UncoMO.ScanGun]
DROP USER [MIDSTATESBOLT\gaywwms10]
DROP USER [MIDSTATESBOLT\lanwwms10]
DROP USER [MIDSTATESBOLT\nilwwms10]
DROP USER [MIDSTATESBOLT\norwwms10]
DROP USER [MIDSTATESBOLT\perwwms10]
DROP USER [MIDSTATESBOLT\sagwwms10]
DROP USER [MIDSTATESBOLT\shewwms10]
DROP USER [MIDSTATESBOLT\stawwms10]
DROP USER [MIDSTATESBOLT\gaywwms11]
DROP USER [MIDSTATESBOLT\lanwwms11]
DROP USER [MIDSTATESBOLT\nilwwms11]
DROP USER [MIDSTATESBOLT\norwwms11]
DROP USER [MIDSTATESBOLT\perwwms11]
DROP USER [MIDSTATESBOLT\sagwwms11]
DROP USER [MIDSTATESBOLT\shewwms11]
DROP USER [MIDSTATESBOLT\stawwms11]
DROP USER [MIDSTATESBOLT\stawwms6]
DROP USER [MIDSTATESBOLT\gaywwms7]
DROP USER [MIDSTATESBOLT\lanwwms7]
DROP USER [MIDSTATESBOLT\norwwms7]
DROP USER [MIDSTATESBOLT\perwwms7]
DROP USER [MIDSTATESBOLT\sagwwms7]
DROP USER [MIDSTATESBOLT\shewwms7]
DROP USER [MIDSTATESBOLT\stawwms7]
DROP USER [MIDSTATESBOLT\shewwms6]
DROP USER [MIDSTATESBOLT\sagwwms6]
DROP USER [MIDSTATESBOLT\perwwms6]
DROP USER [MIDSTATESBOLT\norwwms6]
DROP USER [MIDSTATESBOLT\nilwwms6]
DROP USER [MIDSTATESBOLT\lanwwms6]
DROP USER [MIDSTATESBOLT\gaywwms6]
DROP USER [MIDSTATESBOLT\pkgwwms5]
DROP USER [MIDSTATESBOLT\pkgwwms4]
DROP USER [MIDSTATESBOLT\stawwms12]
DROP USER [MIDSTATESBOLT\shewwms12]
DROP USER [MIDSTATESBOLT\gaywwms8]
DROP USER [MIDSTATESBOLT\lanwwms8]
DROP USER [MIDSTATESBOLT\nilwwms8]
DROP USER [MIDSTATESBOLT\pkgwwms3]
DROP USER [MIDSTATESBOLT\norwwms8]
DROP USER [MIDSTATESBOLT\sagwwms8]
DROP USER [MIDSTATESBOLT\shewwms8]
DROP USER [MIDSTATESBOLT\stawwms8]
DROP USER [MIDSTATESBOLT\gaywwms9]
DROP USER [MIDSTATESBOLT\lanwwms9]
DROP USER [MIDSTATESBOLT\nilwwms9]
DROP USER [MIDSTATESBOLT\norwwms9]
DROP USER [MIDSTATESBOLT\perwwms9]
DROP USER [MIDSTATESBOLT\sagwwms9]
DROP USER [MIDSTATESBOLT\shewwms9]
DROP USER [MIDSTATESBOLT\stawwms9]
DROP USER [MIDSTATESBOLT\gaywwms12]
DROP USER [MIDSTATESBOLT\lanwwms12]
DROP USER [MIDSTATESBOLT\nilwwms12]
DROP USER [MIDSTATESBOLT\norwwms12]
DROP USER [MIDSTATESBOLT\perwwms12]
DROP USER [MIDSTATESBOLT\sagwwms12]
DROP USER [MIDSTATESBOLT\Nina.Brewer]
DROP USER [MIDSTATESBOLT\Jordon.Ham]
DROP USER [MIDSTATESBOLT\Randy.Allers]
DROP USER [MIDSTATESBOLT\Gregory.Pamer]
DROP USER [MIDSTATESBOLT\perwwms8]
DROP USER [MIDSTATESBOLT\Melody.Compton]
DROP USER [MIDSTATESBOLT\Extang.ScanGun]
DROP USER [MIDSTATESBOLT\nilwwms7]
DROP USER [MIDSTATESBOLT\Daman]
DROP USER [MIDSTATESBOLT\Daman.ScanGun]
DROP USER [MIDSTATESBOLT\Metalworks.ScanGun]
DROP USER [MIDSTATESBOLT\P21EDASyncUser]
DROP USER [MIDSTATESBOLT\BoL.ScanGun]
DROP USER [MIDSTATESBOLT\SQLAgent]
DROP USER [MIDSTATESBOLT\P21User]
DROP USER [MIDSTATESBOLT\Jimmy.Colley]
DROP USER [MIDSTATESBOLT\AAR6th.ScanGun]
DROP USER atcuser
DROP USER [B-Agent]
DROP USER Binapp
DROP USER Crystal
DROP USER B2BSELLER
DROP USER epicorMWSQLUser

use master; create login [NTSFDSQL01\alexb] 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\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\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\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\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\heathers] from windows with default_database=P21;
use master; create login [NTSFDSQL01\itdept] 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\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\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\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\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;


use P21; create user [NTSFDSQL01\alexb] from login [NTSFDSQL01\alexb];
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\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\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\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\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\heathers] from login [NTSFDSQL01\heathers];
use P21; create user [NTSFDSQL01\itdept] from login [NTSFDSQL01\itdept];
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\johns] from login [NTSFDSQL01\johns];
use P21; 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\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\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\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];


EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\alexb];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\amyw];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\andyd];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\aprild];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\billg];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\brendac];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\bryana];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\burpkg1];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\chrisw];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\craigb];
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\Eddie.kubacki];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\ericw];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\fredr];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\heathers];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\itdept];
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\johns];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\kenr];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\kevin.weathers];
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\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\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];


use master; create login [NTSFDSQL01\amy.bevis] from windows with default_database=P21;
use P21; create user [NTSFDSQL01\amy.bevis] from login [NTSFDSQL01\amy.bevis];
EXEC sp_addrolemember [PxxiUser], [NTSFDSQL01\amy.bevis];

Grant select on nutech_fn_branch_wwms_performance_report to [PxxiUser]
Grant select on nutech_fn_inventory_received_report to [PxxiUser]
Grant select on nutech_fn_inventory_received_summary_report to [PxxiUser]
Grant select on nutech_fn_inventory_sales_report to [PxxiUser]
Grant select on nutech_fn_item_fill_report to [PxxiUser]
Grant select on nutech_fn_kit_costs to [PxxiUser]
Grant select on nutech_fn_kit_costs_report to [PxxiUser]
Grant select on nutech_fn_kit_costs2 to [PxxiUser]
Grant select on nutech_fn_kit_items to [PxxiUser]
Grant select on nutech_fn_kit_items_report to [PxxiUser]
Grant select on nutech_fn_kit_items_w_costs to [PxxiUser]
Grant select on nutech_fn_kit_items_w_costs_report to [PxxiUser]
Grant select on nutech_fn_kit_items_w_costs_report2 to [PxxiUser]
Grant select on nutech_fn_kit_items_w_costs2 to [PxxiUser]
Grant select on nutech_fn_kit_subkits to [PxxiUser]
Grant select on nutech_fn_terms_eval_report to [PxxiUser]
Grant select on nutech_fn_terms_eval_report_test to [PxxiUser]
Grant select on nutech_fn_vendor_sales_prior_years_report to [PxxiUser]
Grant select on nutech_multi_valued_user_input_parameter to [PxxiUser]

-- Views
Grant select on nutech_item_last_invoice_view to [PxxiUser]
Grant select on nutech_sales_history_report_view to [PxxiUser]
Grant select on nutech_view_open_orders_report to [PxxiUser]
Grant select on nutech_view_purchase_order_quote_report to [PxxiUser]





select object_name(major_id) as object,
 user_name(grantee_principal_id) as grantee,
 user_name(grantor_principal_id) as grantor,
 permission_name,
 state_desc
from sys.database_permissions