Rem
Rem $Header: dfltpass.sql 22-feb-2006.18:10:02 mfallon Exp $
Rem
Rem dfltpass.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.
Rem
Rem NAME
Rem dfltpass.sql - scan for default username / passwords
Rem
Rem DESCRIPTION
Rem Scan the database schema accounts looking for default
Rem username / password combinations. User list includes
Rem accounts from Database, iAS, OCS, EM, E-Business Suite,
Rem PeopleSoft and JD Edwards
Rem
Rem NOTES
Rem Needs read access to dba_users table
Rem
Rem MODIFIED (MM/DD/YY)
Rem dwiles 03/29/06 - Refreshed list of default accounts and
Rem passwords
Rem dwiles 03/14/06 - Removed spaces incorrectly included in
Rem JD Edwards password hashes
Rem dwiles 02/23/06 - Refreshed list of default accounts and
Rem passwords
Rem mfallon 12/23/05 - SQL Script to check for default account /
Rem passwords
Rem mfallon 12/23/05 - Created
Rem
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100
SET ESCAPE ON
TTITLE "Default Accounts With Default Passwords"
SELECT
username "Account Name", account_status "Account Status"
FROM sys.dba_users
WHERE (username, password) IN (
('AASH', '9B52488370BB3D77'),
('ABA1', '30FD307004F350DE'),
('ABM', 'D0F2982F121C7840'),
('AD_MONITOR', '54F0C83F51B03F49'),
('ADAMS', '72CDEF4A3483F60D'),
('ADS', 'D23F0F5D871EB69F'),
('ADSEUL_US', '4953B2EB6FCB4339'),
('AHL', '7910AE63C9F7EEEE'),
('AHM', '33C2E27CF5E401A4'),
('AK', '8FCB78BBA8A59515'),
('AL', '384B2C568DE4C2B5'),
('ALA1', '90AAC5BD7981A3BA'),
('ALLUSERS', '42F7CD03B7D2CA0F'),
('ALR', 'BE89B24F9F8231A9'),
('AMA1', '585565C23AB68F71'),
('AMA2', '37E458EE1688E463'),
('AMA3', '81A66D026DC5E2ED'),
('AMA4', '194CCC94A481DCDE'),
('AMF', 'EC9419F55CDC666B'),
('AMS', 'BD821F59270E5F34'),
('AMS1', 'DB8573759A76394B'),
('AMS2', 'EF611999C6AD1FD7'),
('AMS3', '41D1084F3F966440'),
('AMS4', '5F5903367FFFB3A3'),
('AMSYS', '4C1EF14ECE13B5DE'),
('AMV', '38BC87EB334A1AC4'),
('AMW', '0E123471AACA2A62'),
('ANNE', '1EEA3E6F588599A6'),
('ANONYMOUS', '94C33111FD9C66F3'),
('AOLDEMO', 'D04BBDD5E643C436'),
('AP', 'EED09A552944B6AD'),
('APA1', 'D00197BF551B2A79'),
('APA2', '121C6F5BD4674A33'),
('APA3', '5F843C0692560518'),
('APA4', 'BF21227532D2794A'),
('APPLEAD', '5331DB9C240E093B'),
('APPLSYS', '0F886772980B8C79'),
('APPLSYS', 'E153FFF4DAE6C9F7'),
('APPLSYSPUB', 'D2E3EF40EE87221E'),
('APPS', 'D728438E8A5925E0'),
('APS1', 'F65751C55EA079E6'),
('APS2', '5CACE7B928382C8B'),
('APS3', 'C786695324D7FB3B'),
('APS4', 'F86074C4F4F82D2C'),
('AQDEMO', '5140E342712061DD'),
('AQJAVA', '8765D2543274B42E'),
('AQUSER', '4CF13BDAC1D7511C'),
('AR', 'BBBFE175688DED7E'),
('ARA1', '4B9F4E0667857EB8'),
('ARA2', 'F4E52BFBED4652CD'),
('ARA3', 'E3D8D73AE399F7FE'),
('ARA4', '758FD31D826E9143'),
('ARS1', '433263ED08C7A4FD'),
('ARS2', 'F3AF9F26D0213538'),
('ARS3', 'F6755F08CC1E7831'),
('ARS4', '452B5A381CABB241'),
('ART', '665168849666C4F3'),
('ASF', 'B6FD427D08619EEE'),
('ASG', '1EF8D8BD87CF16BE'),
('ASL', '03B20D2C323D0BFE'),
('ASN', '1EE6AEBD9A23D4E0'),
('ASO', 'F712D80109E3C9D8'),
('ASP', 'CF95D2C6C85FF513'),
('AST', 'F13FF949563EAB3C'),
('AUC_GUEST', '8A59D349DAEC26F7'),
('AURORA$ORB$UNAUTHENTICATED', '80C099F0EADF877E'),
('AUTHORIA', 'CC78120E79B57093'),
('AX', '0A8303530E86FCDD'),
('AZ', 'AAA18B5D51B0D5AC'),
('B2B', 'CC387B24E013C616'),
('BAM', '031091A1D1A30061'),
('BCA1', '398A69209360BD9D'),
('BCA2', '801D9C90EBC89371'),
('BEN', '9671866348E03616'),
('BIC', 'E84CC95CBBAC1B67'),
('BIL', 'BF24BCE2409BE1F7'),
('BIM', '6026F9A8A54B9468'),
('BIS', '7E9901882E5F3565'),
('BIV', '2564B34BE50C2524'),
('BIX', '3DD36935EAEDE2E3'),
('BLAKE', '9435F2E60569158E'),
('BMEADOWS', '2882BA3D3EE1F65A'),
('BNE', '080B5C7EE819BF78'),
('BOM', '56DB3E89EAE5788E'),
('BP01', '612D669D2833FACD'),
('BP02', 'FCE0C089A3ECECEE'),
('BP03', '0723FFEEFBA61545'),
('BP04', 'E5797698E0F8934E'),
('BP05', '58FFC821F778D7E9'),
('BP06', '2F358909A4AA6059'),
('BSC', 'EC481FD7DCE6366A'),
('BUYACCT', 'D6B388366ECF2F61'),
('BUYAPPR1', 'CB04931693309228'),
('BUYAPPR2', '3F98A3ADC037F49C'),
('BUYAPPR3', 'E65D8AD3ACC23DA3'),
('BUYER', '547BDA4286A2ECAE'),
('BUYMTCH', '0DA5E3B504CC7497'),
('CAMRON', '4384E3F9C9C9B8F1'),
('CANDICE', 'CF458B3230215199'),
('CARL', '99ECCC664FFDFEA2'),
('CARLY', 'F7D90C099F9097F1'),
('CARMEN', '46E23E1FD86A4277'),
('CARRIECONYERS', '9BA83B1E43A5885B'),
('CATADMIN', 'AF9AB905347E004F'),
('CE', 'E7FDFE26A524FE39'),
('CEASAR', 'E69833B8205D5DD7'),
('CENTRA', '63BF5FFE5E3EA16D'),
('CFD', '667B018D4703C739'),
('CHANDRA', '184503FA7786C82D'),
('CHARLEY', 'E500DAA705382E8D'),
('CHRISBAKER', '52AFB6B3BE485F81'),
('CHRISTIE', 'C08B79CCEC43E798'),
('CINDY', '3AB2C717D1BD0887'),
('CLARK', '74DF527800B6D713'),
('CLARK', '7AAFE7D01511D73F'),
('CLAUDE', 'C6082BCBD0B69D20'),
('CLINT', '163FF8CCB7F11691'),
('CLN', 'A18899D42066BFCA'),
('CN', '73F284637A54777D'),
('CNCADMIN', 'C7C8933C678F7BF9'),
('CONNIE', '982F4C420DD38307'),
('CONNOR', '52875AEB74008D78'),
('CORY', '93CE4CCE632ADCD2'),
('CRM1', '6966EA64B0DFC44E'),
('CRM2', 'B041F3BEEDA87F72'),
('CRP', 'F165BDE5462AD557'),
('CRPB733', '2C9AB93FF2999125'),
('CRPCTL', '4C7A200FB33A531D'),
('CRPDTA', '6665270166D613BC'),
('CS', 'DB78866145D4E1C3'),
('CSADMIN', '94327195EF560924'),
('CSAPPR1', '47D841B5A01168FF'),
('CSC', 'EDECA9762A8C79CD'),
('CSD', '144441CEBAFC91CF'),
('CSDUMMY', '7A587C459B93ACE4'),
('CSE', 'D8CC61E8F42537DA'),
('CSF', '684E28B3C899D42C'),
('CSI', '71C2B12C28B79294'),
('CSL', 'C4D7FE062EFB85AB'),
('CSM', '94C24FC0BE22F77F'),
('CSMIG', '09B4BB013FBD0D65'),
('CSP', '5746C5E077719DB4'),
('CSR', '0E0F7C1B1FE3FA32'),
('CSS', '3C6B8C73DDC6B04F'),
('CTXDEMO', 'CB6B5E9D9672FE89'),
('CTXSYS', '24ABAB8B06281B4C'),
('CTXSYS', '71E687F036AD56E5'),
('CTXTEST', '064717C317B551B6'),
('CUA', 'CB7B2E6FFDD7976F'),
('CUE', 'A219FE4CA25023AA'),
('CUF', '82959A9BD2D51297'),
('CUG', '21FBCADAEAFCC489'),
('CUI', 'AD7862E01FA80912'),
('CUN', '41C2D31F3C85A79D'),
('CUP', 'C03082CD3B13EC42'),
('CUS', '00A12CC6EBF8EDB8'),
('CZ', '9B667E9C5A0D21A6'),
('DAVIDMORGAN', 'B717BAB262B7A070'),
('DBSNMP', 'E066D214D5421CCC'),
('DCM', '45CCF86E1058D3A5'),
('DD7333', '44886308CF32B5D4'),
('DD7334', 'D7511E19D9BD0F90'),
('DD810', '0F9473D8D8105590'),
('DD811', 'D8084AE609C9A2FD'),
('DD812', 'AB71915CF21E849E'),
('DD9', 'E81821D03070818C'),
('DDB733', '7D11619CEE99DE12'),
('DDD', '6CB03AF4F6DD133D'),
('DEMO8', '0E7260738FDFD678'),
('DES', 'ABFEC5AC2274E54D'),
('DES2K', '611E7A73EC4B425A'),
('DEV2000_DEMOS', '18A0C8BD6B13BEE2'),
('DEVB733', '7500DF89DC99C057'),
('DEVUSER', 'C10B4A80D00CA7A5'),
('DGRAY', '5B76A1EB8F212B85'),
('DIP', 'CE4A36B8E06CA59C'),
('DISCOVERER5', 'AF0EDB66D914B731'),
('DKING', '255C2B0E1F0912EA'),
('DLD', '4454B932A1E0E320'),
('DMADMIN', 'E6681A8926B40826'),
('DMATS', '8C692701A4531286'),
('DMS', '1351DC7ED400BD59'),
('DMSYS', 'BFBA5A553FD9E28A'),
('DOM', '51C9F2BECA78AE0E'),
('DPOND', '79D6A52960EEC216'),
('DSGATEWAY', '6869F3CFD027983A'),
('DV7333', '36AFA5CD674BA841'),
('DV7334', '473B568021BDB428'),
('DV810', '52C38F48C99A0352'),
('DV811', 'B6DC5AAB55ECB66C'),
('DV812', '7359E6E060B945BA'),
('DV9', '07A1D03FD26E5820'),
('DVP1', '0559A0D3DE0759A6'),
('EAA', 'A410B2C5A0958CDF'),
('EAM', 'CE8234D92FCFB563'),
('EC', '6A066C462B62DD46'),
('ECX', '0A30645183812087'),
('EDR', '5FEC29516474BB3A'),
('EDWEUL_US', '5922BA2E72C49787'),
('EDWREP', '79372B4AB748501F'),
('EGC1', 'D78E0F2BE306450D'),
('EGD1', 'DA6D6F2089885BA6'),
('EGM1', 'FB949D5E4B5255C0'),
('EGO', 'B9D919E5F5A9DA71'),
('EGR1', 'BB636336ADC5824A'),
('END1', '688499930C210B75'),
('ENG', '4553A3B443FB3207'),
('ENI', '05A92C0958AFBCBC'),
('ENM1', '3BDABFD1246BFEA2'),
('ENS1', 'F68A5D0D6D2BB25B'),
('ENTMGR_CUST', '45812601EAA2B8BD'),
('ENTMGR_PRO', '20002682991470B3'),
('ENTMGR_TRAIN', 'BE40A3BE306DD857'),
('EOPP_PORTALADM', 'B60557FD8C45005A'),
('EOPP_PORTALMGR', '9BB3CF93F7DE25F1'),
('EOPP_USER', '13709991FC4800A1'),
('EUL_US', '28AEC22561414B29'),
('EVM', '137CEDC20DE69F71'),
('EXA1', '091BCD95EE112EE3'),
('EXA2', 'E4C0A21DBD06B890'),
('EXA3', '40DC4FA801A73560'),
('EXA4', '953885D52BDF5C86'),
('EXFSYS', '66F4EF5650C20355'),
('EXS1', 'C5572BAB195817F0'),
('EXS2', '8FAA3AC645793562'),
('EXS3', 'E3050174EE1844BA'),
('EXS4', 'E963BFE157475F7D'),
('FA', '21A837D0AED8F8E5'),
('FEM', 'BD63D79ADF5262E7'),
('FIA1', '2EB76E07D3E094EC'),
('FII', 'CF39DE29C08F71B9'),
('FLM', 'CEE2C4B59E7567A3'),
('FNI1', '308839029D04F80C'),
('FNI2', '05C69C8FEAB4F0B9'),
('FPA', '9FD6074B9FD3754C'),
('FPT', '73E3EC9C0D1FAECF'),
('FRM', '9A2A7E2EBE6E4F71'),
('FTA1', '65FF9AB3A49E8A13'),
('FTE', '2FB4D2C9BAE2CCCA'),
('FUN', '8A7055CA462DB219'),
('FV', '907D70C0891A85B1'),
('FVP1', '6CC7825EADF994E8'),
('GALLEN', 'F8E8ED9F15842428'),
('GCA1', '47DA9864E018539B'),
('GCA2', 'FD6E06F7DD50E868'),
('GCA3', '4A4B9C2E9624C410'),
('GCA9', '48A7205A4C52D6B5'),
('GCMGR1', '14A1C1A08EA915D6'),
('GCMGR2', 'F4F11339A4221A4D'),
('GCMGR3', '320F0D4258B9D190'),
('GCS', '7AE34CA7F597EBF7'),
('GCS1', '2AE8E84D2400E61D'),
('GCS2', 'C242D2B83162FF3D'),
('GCS3', 'DCCB4B49C68D77E2'),
('GEORGIAWINE', 'F05B1C50A1C926DE'),
('GL', 'CD6E99DACE4EA3A6'),
('GLA1', '86C88007729EB36F'),
('GLA2', '807622529F170C02'),
('GLA3', '863A20A4EFF7386B'),
('GLA4', 'DB882CF89A758377'),
('GLS1', '7485C6BD564E75D1'),
('GLS2', '319E08C55B04C672'),
('GLS3', 'A7699C43BB136229'),
('GLS4', '7C171E6980BE2DB9'),
('GM_AWDA', '4A06A107E7A3BB10'),
('GM_COPI', '03929AE296BAAFF2'),
('GM_DPHD', '0519252EDF68FA86'),
('GM_MLCT', '24E8B569E8D1E93E'),
('GM_PLADMA', '2946218A27B554D8'),
('GM_PLADMH', '2F6EDE96313AF1B7'),
('GM_PLCCA', '7A99244B545A038D'),
('GM_PLCCH', '770D9045741499E6'),
('GM_PLCOMA', '91524D7DE2B789A8'),
('GM_PLCOMH', 'FC1C6E0864BF0AF2'),
('GM_PLCONA', '1F531397B19B1E05'),
('GM_PLCONH', 'C5FE216EB8FCD023'),
('GM_PLNSCA', 'DB9DD2361D011A30'),
('GM_PLNSCH', 'C80D557351110D51'),
('GM_PLSCTA', '3A778986229BA20C'),
('GM_PLSCTH', '9E50865473B63347'),
('GM_PLVET', '674885FDB93D34B9'),
('GM_SPO', 'E57D4BD77DAF92F0'),
('GM_STKH', 'C498A86BE2663899'),
('GMA', 'DC7948E807DFE242'),
('GMD', 'E269165256F22F01'),
('GME', 'B2F0E221F45A228F'),
('GMF', 'A07F1956E3E468E1'),
('GMI', '82542940B0CF9C16'),
('GML', '5F1869AD455BBA73'),
('GMP', '450793ACFCC7B58E'),
('GMS', 'E654261035504804'),
('GR', 'F5AB0AA3197AEE42'),
('GUEST', '1C0A090E404CECD0'),
('HCC', '25A25A7FEFAC17B6'),
('HHCFO', '62DF37933FB35E9F'),
('HR', '4C6D73C3E8B0F0DA'),
('HRI', '49A3A09B8FC291D0'),
('HXC', '4CEA0BF02214DA55'),
('HXT', '169018EB8E2C4A77'),
('IA', '42C7EAFBCEEC09CC'),
('IBA', '0BD475D5BF449C63'),
('IBC', '9FB08604A30A4951'),
('IBE', '9D41D2B3DD095227'),
('IBP', '840267B7BD30C82E'),
('IBU', '0AD9ABABC74B3057'),
('IBY', 'F483A48F6A8C51EC'),
('ICX', '7766E887AF4DCC46'),
('IEB', 'A695699F0F71C300'),
('IEC', 'CA39F929AF0A2DEC'),
('IEM', '37EF7B2DD17279B5'),
('IEO', 'E93196E9196653F1'),
('IES', '30802533ADACFE14'),
('IEU', '5D0E790B9E882230'),
('IEX', '6CC978F56D21258D'),
('IGC', 'D33CEB8277F25346'),
('IGF', '1740079EFF46AB81'),
('IGI', '8C69D50E9D92B9D0'),
('IGS', 'DAF602231281B5AC'),
('IGW', 'B39565F4E3CF744B'),
('IMC', 'C7D0B9CDE0B42C73'),
('IMT', 'E4AAF998653C9A72'),
('INS1', '2ADC32A0B154F897'),
('INS2', 'EA372A684B790E2A'),
('INTERNET_APPSERVER_REGISTRY', 'A1F98A977FFD73CD'),
('INV', 'ACEAB015589CF4BC'),
('IP', 'D29012C144B58A40'),
('IPA', 'EB265A08759A15B4'),
('IPD', '066A2E3072C1F2F3'),
('ISC', '373F527DC0CFAE98'),
('ISTEWARD', '8735CA4085DE3EEA'),
('ITG', 'D90F98746B68E6CA'),
('JA', '9AC2B58153C23F3D'),
('JD7333', 'FB5B8A12AE623D52'),
('JD7334', '322810FCE43285D9'),
('JD9', '9BFAEC92526D027B'),
('JDE', '7566DC952E73E869'),
('JDEDBA', 'B239DD5313303B1D'),
('JE', 'FBB3209FD6280E69'),
('JG', '37A99698752A1CF1'),
('JL', '489B61E488094A8D'),
('JOHNINARI', 'B3AD4DA00F9120CE'),
('JONES', 'B9E99443032F059D'),
('JTF', '5C5F6FC2EBB94124'),
('JTI', 'B8F03D3E72C96F71'),
('JTM', '6D79A2259D5B4B5A'),
('JTR', 'B4E2BE38B556048F'),
('JTS', '4087EE6EB7F9CD7C'),
('JUNK_PS', 'BBC38DB05D2D3A7A'),
('JUSTOSHUM', '53369CD63902FAAA'),
('KELLYJONES', 'DD4A3FF809D2A6CF'),
('KEVINDONS', '7C6D9540B45BBC39'),
('KPN', 'DF0AED05DE318728'),
('LADAMS', 'AE542B99505CDCD2'),
('LBA', '18E5E15A436E7157'),
('LBACSYS', 'AC9700FD3F1410EB'),
('LDQUAL', '1274872AB40D4FCD'),
('LHILL', 'E70CA2CA0ED555F5'),
('LNS', 'F8D2BC61C10941B2'),
('LQUINCY', '13F9B9C1372A41B6'),
('LSA', '2D5E6036E3127B7E'),
('MDDATA', 'DF02A496267DEE66'),
('MDSYS', '72979A94BAD2AF80'),
('MDSYS', '9AAEB2214DCC9A31'),
('ME', 'E5436F7169B29E4D'),
('MFG', 'FC1B0DD35E790847'),
('MGR1', 'E013305AB0185A97'),
('MGR2', '5ADE358F8ACE73E8'),
('MGR3', '05C365C883F1251A'),
('MGR4', 'E229E942E8542565'),
('MIKEIKEGAMI', 'AAF7A168C83D5C47'),
('MJONES', 'EE7BB3FEA50A21C5'),
('MLAKE', '7EC40274AC1609CA'),
('MM1', '4418294570E152E7'),
('MM2', 'C06B5B28222E1E62'),
('MM3', 'A975B1BD0C093DA3'),
('MM4', '88256901EB03A012'),
('MM5', '4CEA62CBE776DCEC'),
('MMARTIN', 'D52F60115FE87AA4'),
('MOBILEADMIN', '253922686A4A45CC'),
('MRP', 'B45D4DF02D4E0C85'),
('MSC', '89A8C104725367B2'),
('MSD', '6A29482069E23675'),
('MSO', '3BAA3289DB35813C'),
('MSR', 'C9D53D00FE77D813'),
('MST', 'A96D2408F62BE1BC'),
('MWA', '1E2F06BE2A1D41A6'),
('NEILKATSU', '1F625BB9FEBC7617'),
('OBJ7333', 'D7BDC9748AFEDB52'),
('OBJ7334', 'EB6C5E9DB4643CAC'),
('OBJB733', '61737A9F7D54EF5F'),
('OCA', '9BC450E4C6569492'),
('ODM', 'C252E8FA117AF049'),
('ODM_MTR', 'A7A32CD03D3CE8D5'),
('ODS', '89804494ADFC71BC'),
('ODSCOMMON', '59BBED977430C1A8'),
('OE', 'D1A2DFC623FDA40A'),
('OKB', 'A01A5F0698FC9E31'),
('OKC', '31C1DDF4D5D63FE6'),
('OKE', 'B7C1BB95646C16FE'),
('OKI', '991C817E5FD0F35A'),
('OKL', 'DE058868E3D2B966'),
('OKO', '6E204632EC7CA65D'),
('OKR', 'BB0E28666845FCDC'),
('OKS', 'C2B4C76AB8257DF5'),
('OKX', 'F9FDEB0DE52F5D6B'),
('OL810', 'E2DA59561CBD0296'),
('OL811', 'B3E88767A01403F8'),
('OL812', 'AE8C7989346785BA'),
('OL9', '17EC83E44FB7DB5B'),
('OLAPSYS', '3FB8EF9DB538647C'),
('ONT', '9E3C81574654100A'),
('OPI', '1BF23812A0AEEDA0'),
('ORABAM', 'D0A4EA93EF21CE25'),
('ORABAMSAMPLES', '507F11063496F222'),
('ORABPEL', '26EFDE0C9C051988'),
('ORAESB', 'CC7FCCB3A1719EDA'),
('ORAOCA_PUBLIC', 'FA99021634DDC111'),
('ORASAGENT', '234B6F4505AD8F25'),
('ORASSO', 'F3701A008AA578CF'),
('ORASSO_DS', '17DC8E02BC75C141'),
('ORASSO_PA', '133F8D161296CB8F'),
('ORASSO_PS', '63BB534256053305'),
('ORASSO_PUBLIC', 'C6EED68A8F75F5D3'),
('ORDPLUGINS', '88A2B2C183431F00'),
('ORDSYS', '7EFA02EC7EA6B86F'),
('OSM', '106AE118841A5D8C'),
('OTA', 'F5E498AC7009A217'),
('OUTLN', '4A3BA55E08595C81'),
('OWAPUB', '6696361B64F9E0A9'),
('OWF_MGR', '3CBED37697EB01D1'),
('OZF', '970B962D942D0C75'),
('OZP', 'B650B1BB35E86863'),
('OZS', '0DABFF67E0D33623'),
('PA', '8CE2703752DB36D8'),
('PABLO', '5E309CB43FE2C2FF'),
('PAIGE', '02B6B704DFDCE620'),
('PAM', '1383324A0068757C'),
('PARRISH', '79193FDACFCE46F6'),
('PARSON', 'AE28B2BD64720CD7'),
('PAT', 'DD20769D59F4F7BF'),
('PATORILY', '46B7664BD15859F9'),
('PATRICKSANCHEZ', '47F74BD3AD4B5F0A'),
('PATSY', '4A63F91FEC7980B7'),
('PAUL', '35EC0362643ADD3F'),
('PAULA', 'BB0DC58A94C17805'),
('PAXTON', '4EB5D8FAD3434CCC'),
('PCA1', '8B2E303DEEEEA0C0'),
('PCA2', '7AD6CE22462A5781'),
('PCA3', 'B8194D12FD4F537D'),
('PCA4', '83AD05F1D0B0C603'),
('PCS1', '2BE6DD3D1DEA4A16'),
('PCS2', '78117145145592B1'),
('PCS3', 'F48449F028A065B1'),
('PCS4', 'E1385509C0B16BED'),
('PD7333', '5FFAD8604D9DC00F'),
('PD7334', 'CDCF262B5EE254E1'),
('PD810', 'EB04A177A74C6BCB'),
('PD811', '3B3C0EFA4F20AC37'),
('PD812', 'E73A81DB32776026'),
('PD9', 'CACEB3F9EA16B9B7'),
('PDA1', 'C7703B70B573D20F'),
('PEARL', 'E0AFD95B9EBD0261'),
('PEG', '20577ED9A8DB8D22'),
('PENNY', 'BB6103E073D7B811'),
('PEOPLE', '613459773123B38A'),
('PERCY', 'EB9E8B33A2DDFD11'),
('PERRY', 'D62B14B93EE176B6'),
('PETE', '4040619819A9C76E'),
('PEYTON', 'B7127140004677FC'),
('PHIL', '181446AE258EE2F6'),
('PJI', '5024B1B412CD4AB9'),
('PJM', '021B05DBB892D11F'),
('PMI', 'A7F7978B21A6F65E'),
('PN', 'D40D0FEF9C8DC624'),
('PO', '355CBEC355C10FEF'),
('POA', '2AB40F104D8517A0'),
('POLLY', 'ABC770C112D23DBE'),
('POM', '123CF56E05D4EF3C'),
('PON', '582090FD3CC44DA3'),
('PORTAL', 'A96255A27EC33614'),
('PORTAL_APP', '831A79AFB0BD29EC'),
('PORTAL_DEMO', 'A0A3A6A577A931A3'),
('PORTAL_PUBLIC', '70A9169655669CE8'),
('PORTAL30', '969F9C3839672C6D'),
('PORTAL30_DEMO', 'CFD1302A7F832068'),
('PORTAL30_PUBLIC', '42068201613CA6E2'),
('PORTAL30_SSO', '882B80B587FCDBC8'),
('PORTAL30_SSO_PS', 'F2C3DC8003BC90F8'),
('PORTAL30_SSO_PUBLIC', '98741BDA2AC7FFB2'),
('POS', '6F6675F272217CF7'),
('PPM1', 'AA4AE24987D0E84B'),
('PPM2', '4023F995FF78077C'),
('PPM3', '12F56FADDA87BBF9'),
('PPM4', '84E17CB7A3B0E769'),
('PPM5', '804C159C660F902C'),
('PRISTB733', '1D1BCF8E03151EF5'),
('PRISTCTL', '78562A983A2F78FB'),
('PRISTDTA', '3FCBC379C8FE079C'),
('PRODB733', '9CCD49EB30CB80C4'),
('PRODCTL', 'E5DE2F01529AE93C'),
('PRODDTA', '2A97CD2281B256BA'),
('PRODUSER', '752E503EFBF2C2CA'),
('PROJMFG', '34D61E5C9BC7147E'),
('PRP', 'C1C4328F8862BC16'),
('PS', '0AE52ADF439D30BD'),
('PS810', '90C0BEC7CA10777E'),
('PS810CTL', 'D32CCE5BDCD8B9F9'),
('PS810DTA', 'AC0B7353A58FC778'),
('PS811', 'B5A174184403822F'),
('PS811CTL', '18EDE0C5CCAE4C5A'),
('PS811DTA', '7961547C7FB96920'),
('PS812', '39F0304F007D92C8'),
('PS812CTL', 'E39B1CE3456ECBE5'),
('PS812DTA', '3780281C933FE164'),
('PSA', 'FF4B266F9E61F911'),
('PSB', '28EE1E024FC55E66'),
('PSBASS', 'F739804B718D4406'),
('PSEM', '40ACD8C0F1466A57'),
('PSFT', '7B07F6F3EC08E30D'),
('PSFTDBA', 'E1ECD83073C4E134'),
('PSP', '4FE07360D435E2F0'),
('PTADMIN', '4C35813E45705EBA'),
('PTCNE', '463AEFECBA55BEE8'),
('PTDMO', '251D71390034576A'),
('PTE', '380FDDB696F0F266'),
('PTESP', '5553404C13601916'),
('PTFRA', 'A360DAD317F583E3'),
('PTG', '7AB0D62E485C9A3D'),
('PTGER', 'C8D1296B4DF96518'),
('PTJPN', '2159C2EAF20011BF'),
('PTUKE', 'D0EF510BCB2992A3'),
('PTUPG', '2C27080C7CC57D06'),
('PTWEB', '8F7F509D4DC01DF6'),
('PTWEBSERVER', '3C8050536003278B'),
('PV', '76224BCC80895D3D'),
('PY7333', '2A9C53FE066B852F'),
('PY7334', 'F3BBFAE0DDC5F7AC'),
('PY810', '95082D35E94B88C2'),
('PY811', 'DC548D6438E4D6B7'),
('PY812', '99C575A55E9FDA63'),
('PY9', 'B8D4E503D0C4FCFD'),
('QA', 'C7AEAA2D59EB1EAE'),
('QOT', 'B27D0E5BA4DC8DEA'),
('QP', '10A40A72991DCA15'),
('QRM', '098286E4200B22DE'),
('QS', '4603BCD2744BDE4F'),
('QS_ADM', '3990FB418162F2A0'),
('QS_CB', '870C36D8E6CD7CF5'),
('QS_CBADM', '20E788F9D4F1D92C'),
('QS_CS', '2CA6D0FC25128CF3'),
('QS_ES', '9A5F2D9F5D1A9EF4'),
('QS_OS', '0EF5997DC2638A61'),
('QS_WS', '0447F2F756B4F460'),
('RENE', '9AAD141AB0954CF0'),
('REPADMIN', '915C93F34954F5F8'),
('REPORTS', '0D9D14FE6653CF69'),
('REPORTS_USER', '635074B4416CD3AC'),
('RESTRICTED_US', 'E7E67B60CFAFBB2D'),
('RG', '0FAA06DA0F42F21F'),
('RHX', 'FFDF6A0C8C96E676'),
('RLA', 'C1959B03F36C9BB2'),
('RLM', '4B16ACDA351B557D'),
('RM1', 'CD43500DAB99F447'),
('RM2', '2D8EE7F8857D477E'),
('RM3', '1A95960A95AC2E1D'),
('RM4', '651BFD4E1DE4B040'),
('RM5', 'FDCC34D74A22517C'),
('RMAN', 'E7B5D92911C831E1'),
('ROB', '94405F516486CA24'),
('RPARKER', 'CEBFE4C41BBCC306'),
('RWA1', 'B07E53895E37DBBB'),
('SALLYH', '21457C94616F5716'),
('SAM', '4B95138CB6A4DB94'),
('SARAHMANDY', '60BE21D8711EE7D9'),
('SCM1', '507306749131B393'),
('SCM2', 'CBE8D6FAC7821E85'),
('SCM3', '2B311B9CDC70F056'),
('SCM4', '1FDF372790D5A016'),
('SCOTT', 'F894844C34402B67'),
('SDAVIS', 'A9A3B88C6A550559'),
('SECDEMO', '009BBE8142502E10'),
('SEDWARDS', '00A2EDFD7835BC43'),
('SELLCM', '8318F67F72276445'),
('SELLER', 'B7F439E172D5C3D0'),
('SELLTREAS', '6EE7BA85E9F84560'),
('SERVICES', 'B2BE254B514118A5'),
('SETUP', '9EA55682C163B9A3'),
('SH', '54B253CBBAAA8C48'),
('SI_INFORMTN_SCHEMA', '84B8CBCA4D477FA3'),
('SID', 'CFA11E6EBA79D33E'),
('SKAYE', 'ED671B63BDDB6B50'),
('SKYTETSUKA', 'EB5DA777D1F756EC'),
('SLSAA', '99064FC6A2E4BBE8'),
('SLSMGR', '0ED44093917BE294'),
('SLSREP', '847B6AAB9471B0A5'),
('SRABBITT', '85F734E71E391DF5'),
('SRALPHS', '975601AA57CBD61A'),
('SRAY', 'C233B26CFC5DC643'),
('SRIVERS', '95FE94ADC2B39E08'),
('SSA1', 'DEE6E1BEB962AA8B'),
('SSA2', '96CA278B20579E34'),
('SSA3', 'C3E8C3B002690CD4'),
('SSC1', '4F7AC652CC728980'),
('SSC2', 'A1350B328E74AE87'),
('SSC3', 'EE3906EC2DA586D8'),
('SSOSDK', '7C48B6FF3D54D006'),
('SSP', '87470D6CE203FB4D'),
('SSS1', 'E78C515C31E83848'),
('SUPPLIER', '2B45928C2FE77279'),
('SVM7333', '04B731B0EE953972'),
('SVM7334', '62E2A2E886945CC8'),
('SVM810', '0A3DCD8CA3B6ABD9'),
('SVM811', '2B0CD57B1091C936'),
('SVM812', '778632974E3947C9'),
('SVM9', '552A60D8F84441F1'),
('SVMB733', 'DD2BFB14346146FE'),
('SVP1', 'F7BF1FFECE27A834'),
('SY810', 'D56934CED7019318'),
('SY811', '2FDC83B401477628'),
('SY812', '812B8D7211E7DEF1'),
('SY9', '3991E64C4BC2EC5D'),
('SYS', '43CA255A7916ECFE'),
('SYS', '5638228DAF52805F'),
('SYS', 'D4C5016086B2DC6A'),
('SYS7333', 'D7CDB3124F91351E'),
('SYS7334', '06959F7C9850F1E3'),
('SYSADMIN', 'DC86E8DEAA619C1A'),
('SYSB733', '7A7F5C90BEC02F0E'),
('SYSMAN', 'EB258E708132DD2D'),
('SYSTEM', '4D27CA6E3E3066E6'),
('SYSTEM', 'D4DF7931AB130E37'),
('TDEMARCO', 'CAB71A14FA426FAE'),
('TDOS_ICSAP', '7C0900F751723768'),
('TESTCTL', '205FA8DF03A1B0A6'),
('TESTDTA', 'EEAF97B5F20A3FA3'),
('TRA1', 'BE8EDAE6464BA413'),
('TRACESVR', 'F9DA8977092B7B81'),
('TRBM1', 'B10ED16CD76DBB60'),
('TRCM1', '530E1F53715105D0'),
('TRDM1', 'FB1B8EF14CF3DEE7'),
('TRRM1', '4F29D85290E62EBE'),
('TWILLIAMS', '6BF819CE663B8499'),
('UDDISYS', 'BF5E56915C3E1C64'),
('VEA', 'D38D161C22345902'),
('VEH', '72A90A786AAE2914'),
('VIDEO31', '2FA72981199F9B97'),
('VIDEO4', '9E9B1524C454EEDE'),
('VIDEO5', '748481CFF7BE98BB'),
('VP1', '3CE03CD65316DBC7'),
('VP2', 'FCCEFD28824DFEC5'),
('VP3', 'DEA4D8290AA247B2'),
('VP4', 'F4730B0FA4F701DC'),
('VP5', '7DD67A696734AE29'),
('VP6', '45660DEE49534ADB'),
('WAA1', 'CF013DC80A9CBEE3'),
('WAA2', '6160E7A17091741A'),
('WCRSYS', '090263F40B744BD8'),
('WEBDB', 'D4C4DCDD41B05A5D'),
('WEBSYS', '54BA0A1CB5994D64'),
('WENDYCHO', '7E628CDDF051633A'),
('WH', '91792EFFCB2464F9'),
('WIP', 'D326D25AE0A0355C'),
('WIRELESS', '1495D279640E6C3A'),
('WIRELESS', 'EB9615631433603E'),
('WK_TEST', '29802572EB547DBF'),
('WKPROXY', 'AA3CB2A4D9188DDB'),
('WKSYS', '545E13456B7DDEA0'),
('WMS', 'D7837F182995E381'),
('WMSYS', '7C9BA362F8314299'),
('WPS', '50D22B9D18547CF7'),
('WSH', 'D4D76D217B02BD7A'),
('WSM', '750F2B109F49CC13'),
('XDB', '88D8364765FCE6AF'),
('XDO', 'E9DDE8ACFA7FE8E4'),
('XDP', 'F05E53C662835FA2'),
('XLA', '2A8ED59E27D86D41'),
('XLE', 'CEEBE966CC6A3E39'),
('XNB', '03935918FA35C993'),
('XNC', 'BD8EA41168F6C664'),
('XNI', 'F55561567EF71890'),
('XNM', '92776EA17B8B5555'),
('XNP', '3D1FB783F96D1F5E'),
('XNS', 'FABA49C38150455E'),
('XTR', 'A43EE9629FA90CAE'),
('YCAMPOS', 'C3BBC657F099A10F'),
('YSANCHEZ', 'E0C033C4C8CC9D84'),
('ZFA', '742E092A27DDFB77'),
('ZPB', 'CAF58375B6D06513'),
('ZSA', 'AFD3BD3C7987CBB6'),
('ZX', '7B06550956254585'))
AND account_status NOT IN ('EXPIRED \& LOCKED' , 'LOCKED')
ORDER BY username;