Skip to content

DEFAULT_PWD$, How and Why

  • by

What is Default Password?

Default passwords are predefined users who has the default password stored in a table called SYS.DEFAULT_PWD$.

In other words, any user who is listed in SYS.DEFAULT_PWD$ is a predefined user, it has the chance to set its password as the default one, even though the user could have not been created yet.

Table SYS.DEFAULT_PWD$ stores usernames and their own default passwords natively in the database. Which means, some users may not exist in your database, but once they have been created, they already have the default password defined in the table.

If an existing user who is using the default password, this makes its account status bit be 16 or larger defined in USER_ASTATUS_MAP.

Who are Predefined Users?

We may query the table to get a list of default usernames predefined by Oracle database.

SQL> column user_name format a30;
SQL> set pagesize 2000;
SQL> select distinct user_name from default_pwd$ order by 1;

USER_NAME
------------------------------
#INTERNAL
AASH
ABA1
ABM
ADAMS
ADLDEMO
ADMIN
ADMINISTRATOR
ADS
ADSEUL_US
AD_MONITOR
AERS68_TO_2003Q3
AERS68_TO_2003Q4
AERS68_TO_2003Q4_REV2
AERS68_TO_2004Q1
AERS68_TO_2004Q2
AERS68_TO_2004Q3
AERS68_TO_2004Q4
AERS68_TO_2005Q1
AERS68_TO_2005Q2
AERS68_TO_2005Q3
AERS68_TO_2005Q4
AERS68_TO_2006Q1
AERS68_TO_2006Q2
AERS68_TO_2006Q3
AERS68_TO_2006Q4
AERS68_TO_2007Q1
AERS68_TO_2007Q2
AERS68_TO_2007Q3
AERS68_TO_2007Q4
AERS68_TO_2008Q1
AERS68_TO_2008Q2
AERS68_TO_2008Q3
AERS68_TO_2008Q4
AERS68_TO_2009Q1
AERS68_TO_2009Q2
AERS68_TO_2009Q3
AERS68_TO_2009Q4
AERS68_TO_2010Q1
AERS68_TO_2010Q1_REV2
AERS68_TO_2010Q2
AERS68_TO_2Q03
AGGREGATE_DB
AHL
AHM
AIA
AK
AL
ALA1
ALHRO
ALHRW
ALLUSERS
ALR
ALT_ADMIN
AMA1
AMA2
AMA3
AMA4
AMF
AMS
AMS1
AMS2
AMS3
AMS4
AMSYS
AMV
AMW
ANDY
ANNE
ANONYMOUS
AOLDEMO
AP
APA1
APA2
APA3
APA4
APEX_040200
APEX_050000
APEX_PUBLIC_USER
APPLEAD
APPLMGR
APPLSYS
APPLSYSPUB
APPLYSYSPUB
APPQOSSYS
APPS
APPS_MRC
APPS_NE
APPUSER
APR_USER
APS1
APS2
APS3
APS4
AQ
AQDEMO
AQJAVA
AQUSER
AR
ARA1
ARA2
ARA3
ARA4
ARCHIVE
ARGUSUSER
ARS1
ARS2
ARS3
ARS4
ART
ASF
ASG
ASL
ASN
ASO
ASP
AST
ATC_2005Q2
ATC_2005Q3
ATC_2005Q4
ATC_2006Q1
ATC_2006Q2
ATC_2006Q3
ATC_2006Q4
ATC_2007Q1
ATC_2007Q2
ATC_2007Q3
ATC_2007Q4
ATC_2008Q1
ATC_2008Q2
ATC_2008Q3
ATC_2008Q4
ATC_2009Q1
ATC_2009Q2
ATC_2009Q3
ATC_2009Q4
ATC_2010Q1
ATC_2010Q2
ATM
AUC_GUEST
AUDIOUSER
AURORA$JIS$UTILITY$
AURORA$ORB$UNAUTHENTICATED
AUTHORIA
AX
AZ
B2B
BAM
BC4J
BC4J_INTERNAL
BCA1
BCA2
BEN
BI
BIC
BIL
BIM
BIREPOS
BIS
BIV
BIX
BLAKE
BLEWIS
BLITZ
BMEADOWS
BNE
BOM
BP01
BP02
BP03
BP04
BP05
BP06
BRIO_ADMIN
BRUGERNAVN
BRUKERNAVN
BSC
BUG_REPORTS
BUYACCT
BUYAPPR1
BUYAPPR2
BUYAPPR3
BUYER
BUYMTCH
CALVIN
CAMRON
CANDICE
CARL
CARLY
CARMEN
CARRIECONYERS
CATADMIN
CATALOG
CCT
CDEMO82
CDEMOCOR
CDEMORID
CDEMOUCB
CDOUGLAS
CDR_DPSERVER
CE
CEASAR
CENTRA
CENTRAL
CFD
CFLUENTDEV
CHANDRA
CHARLEY
CHRISBAKER
CHRISTIE
CIDS
CINDY
CIS
CISINFO
CISUSER
CLARK
CLAUDE
CLIENT_STORAGE
CLINT
CLN
CMI
CN
CNCADMIN
COMPANY
COMPIERE
CONNIE
CONNOR
COREDB
CORY
CQSCHEMAUSER
CQUSERDBUSER
CRM1
CRM2
CRP
CRPB733
CRPCTL
CRPDTA
CS
CSADMIN
CSAPPR1
CSC
CSD
CSDUMMY
CSE
CSF
CSI
CSL
CSM
CSMIG
CSP
CSR
CSS
CTCLASSIFY
CTPROC
CTS
CTSCODES
CTSDD
CTSRM
CTSRP
CTSYS
CTXDEMO
CTXSYS
CTXTEST
CUA
CUE
CUF
CUG
CUI
CUN
CUP
CUS
CXFR_RECV
CXFR_SEND
CZ
DATA_SCHEMA
DAVIDMORGAN
DBI
DBSFWUSER
DBSNMP
DBVISION
DCM
DD7333
DD7334
DD810
DD811
DD812
DD9
DDB733
DDD
DDIC
DDR
DEMO
DEMO8
DEMO9
DES
DES2K
DESIGNER
DEV2000_DEMOS
DEVB733
DEVUSER
DGRAY
DIANE
DIP
DISCOVERER5
DISCOVERER_ADMIN
DKING
DLD
DMADMIN
DMATS
DMS
DMSYS
DNA
DOM
DPF
DPOND
DPP
DSGATEWAY
DSSYS
DTSP
DV7333
DV7334
DV810
DV811
DV812
DV9
DVF
DVP1
DVSYS
EAA
EAM
EARLYWATCH
EAST
EBS_EID_INTEGRATOR
EBS_EID_STUDIO
EC
ECX
EDR
EDWEUL_US
EDWREP
EGC1
EGD1
EGM1
EGO
EGR1
EJB
EJSADMIN
EMP
EM_MONITOR
END1
ENG
ENI
ENM1
ENS1
ENTMGR_CUST
ENTMGR_PRO
ENTMGR_TRAIN
EOPP_PORTALADM
EOPP_PORTALMGR
EOPP_USER
ESTOREUSER
EUL4_US
EUL5_US
EUL6_US
EUL_US
EVENT
EVM
EXA1
EXA2
EXA3
EXA4
EXAMPLE
EXFSYS
EXS1
EXS2
EXS3
EXS4
EXTDEMO
EXTDEMO2
FA
FEM
FIA1
FII
FINANCE
FINPROD
FLM
FLOWS_030000
FLOWS_FILES
FND
FNI1
FNI2
FOD
FOO
FPA
FPT
FRM
FROSTY
FTA1
FTE
FTIMASTER
FTISTAGE
FTIWORK
FTP
FUN
FUSION_ATGLITE
FV
FVP1
GALLEN
GCA1
GCA2
GCA3
GCA9
GCMGR1
GCMGR2
GCMGR3
GCS
GCS1
GCS2
GCS3
GEORGIAWINE
GGSYS
GHG
GL
GLA1
GLA2
GLA3
GLA4
GLOBALREPORTUSER
GLOGDBA
GLOGDEV
GLOGLOAD
GLOGOWNER
GLS1
GLS2
GLS3
GLS4
GMA
GMD
GME
GMF
GMI
GML
GMO
GMP
GMS
GM_AWDA
GM_COPI
GM_DPHD
GM_MLCT
GM_PLADMA
GM_PLADMH
GM_PLCCA
GM_PLCCH
GM_PLCOMA
GM_PLCOMH
GM_PLCONA
GM_PLCONH
GM_PLNSCA
GM_PLNSCH
GM_PLSCTA
GM_PLSCTH
GM_PLVET
GM_SPO
GM_STKH
GPFD
GPLD
GR
GSMADMIN_INTERNAL
GSMCATUSER
GSMUSER
GUEST
HADES
HCC
HCPARK
HDOWNER
HHCFO
HLW
HR
HRI
HVST
HXC
HXT
IA
IBA
IBC
IBE
IBP
IBU
IBW
IBY
ICDBOWN
ICX
IDEMO_USER
IEB
IEC
IEM
IEO
IES
IEU
IEX
IFSSYS
IGC
IGF
IGI
IGS
IGW
IMAGEUSER
IMC
IMEDIA
IMT
INFORMADAPTER0
INFORMADAPTER1
INFORMADAPTER2
INFORMADAPTER3
INFORMADAPTER4
INFORMADAPTER5
INFORMADAPTER6
INFORMADAPTER7
INFORMADAPTER8
INFORMADAPTER9
INFORMADMIN
INL
INS1
INS2
INTERNAL
INTERNET_APPSERVER_REGISTRY
INV
IP
IPA
IPD
IPLANET
IPM
ISC
ISTEWARD
ITA
ITG
IX
IZU
JA
JAKE
JD7333
JD7334
JD9
JDE
JDEDBA
JE
JG
JILL
JL
JMF
JMSUSER
JMUSER
JOHN
JOHNINARI
JONES
JTF
JTI
JTM
JTR
JTS
JUNK_PS
JUSTOSHUM
JWARD
KELLYJONES
KEVINDONS
KPN
KWALKER
L2LDEMO
LABPASREPORT
LADAMS
LBA
LBACSYS
LDQUAL
LHILL
LIBRARIAN
LNS
LOCATION_ACTIVITY_DB
LQUINCY
LSA
MANPROD
MARK
MASCARM
MASTER
MCRSCACHE
MDDATA
MDDEMO
MDDEMO_CLERK
MDDEMO_MGR
MDSYS
ME
MEDDRA100
MEDDRA101
MEDDRA110
MEDDRA111
MEDDRA120
MEDDRA121
MEDDRA130
MEDDRA131
MEDDRA32
MEDDRA33
MEDDRA40
MEDDRA50
MEDDRA51
MEDDRA60
MEDDRA61
MEDDRA70
MEDDRA71
MEDDRA80
MEDDRA81
MEDDRA90
MEDDRA91
MFG
MGDSYS
MGMT_VIEW
MGR
MGR1
MGR2
MGR3
MGR4
MGWUSER
MICROS
MICROSDB
MIGRATE
MIKEIKEGAMI
MILLER
MJONES
MLAKE
MM1
MM2
MM3
MM4
MM5
MMARTIN
MMO2
MOBILEADMIN
MODTEST
MOREAU
MRP
MSC
MSD
MSO
MSR
MST
MTH
MTSSYS
MTS_USER
MWA
MXAGENT
NAMES
NEILKATSU
NEOTIX_SYS
NNEUL
NOMEUTENTE
NOME_UTILIZADOR
NOM_UTILISATEUR
NUME_UTILIZATOR
OADM_REPORT
OADM_SAMPLE
OADM_SYS
OADM_USER
OAS_PUBLIC
OBJ7333
OBJ7334
OBJB733
OCA
OCITEST
OCM_DB_ADMIN
ODM
ODM_MTR
ODS
ODSCOMMON
ODS_SERVER
OE
OEMADM
OEMREP
OEM_REPOSITORY
OJVMSYS
OKB
OKC
OKE
OKI
OKL
OKO
OKR
OKS
OKX
OL810
OL811
OL812
OL9
OLAPDBA
OLAPSVR
OLAPSYS
OMWB_EMULATION
ONT
OO
OPENSPIRIT
OPI
OPS$GUEST1
OPS$GUEST2
OPS$GUEST3
OPS$GUEST4
OPS$GUEST5
OPS$GUEST6
OPS$GUEST7
OPS$GUEST8
OPS$GUEST9
OPS$OPAPPS
OPS$TMSBROWSER
ORABAM
ORABAMSAMPLES
ORABPEL
ORACACHE
ORACLE
ORACLE_OCM
ORADBA
ORAESB
ORANGE
ORAOCA_PUBLIC
ORAPROBE
ORAREGSYS
ORASAGENT
ORASSO
ORASSO_DS
ORASSO_PA
ORASSO_PS
ORASSO_PUBLIC
ORASTAT
ORCLADMIN
ORDCOMMON
ORDDATA
ORDPLUGINS
ORDSYS
OSE$HTTP$ADMIN
OSM
OSP22
OTA
OUTLN
OWA
OWAPUB
OWA_PUBLIC
OWBSYS
OWF_MGR
OWNER
OZF
OZG_BATCH
OZP
OZS
PA
PABLO
PAIGE
PAM
PANAMA
PARRISH
PARSON
PAS
PASJMS
PAT
PATORILY
PATRICKSANCHEZ
PATROL
PATSY
PAUL
PAULA
PAXTON
PCA1
PCA2
PCA3
PCA4
PCS1
PCS2
PCS3
PCS4
PD7333
PD7334
PD810
PD811
PD812
PD9
PDA1
PEARL
PEG
PENNY
PEOPLE
PERCY
PERFSTAT
PERRY
PERSTAT
PETE
PEYTON
PFDBADMIN
PFT
PHIL
PJI
PJM
PLANNING
PLEX
PLM
PLSQL
PM
PMI
PN
PO
PO7
PO8
POA
POLLY
POM
PON
PORTAL
PORTAL30
PORTAL30_ADMIN
PORTAL30_DEMO
PORTAL30_PS
PORTAL30_PUBLIC
PORTAL30_SSO
PORTAL30_SSO_ADMIN
PORTAL30_SSO_PS
PORTAL30_SSO_PUBLIC
PORTAL_APP
PORTAL_DB
PORTAL_DEMO
PORTAL_PUBLIC
PORTAL_SSO_PS
POS
POWERCARTUSER
PPM1
PPM2
PPM3
PPM4
PPM5
PRIMARY
PRISTB733
PRISTCTL
PRISTDTA
PRODB733
PRODCTL
PRODDTA
PRODUSER
PROJMFG
PRP
PS
PS810
PS810CTL
PS810DTA
PS811
PS811CTL
PS811DTA
PS812
PS812CTL
PS812DTA
PSA
PSB
PSBASS
PSEM
PSFT
PSFTDBA
PSP
PTADMIN
PTCNE
PTDMO
PTE
PTESP
PTFRA
PTG
PTGER
PTJPN
PTUKE
PTUPG
PTWEB
PTWEBSERVER
PUBSUB
PUBSUB1
PV
PXFR_RECV
PXFR_SEND
PY7333
PY7334
PY810
PY811
PY812
PY9
QA
QDBA
QOT
QP
QPR
QRM
QS
QS_ADM
QS_CB
QS_CBADM
QS_CS
QS_ES
QS_OS
QS_WS
QUARTZ
RDW13DEV
RDWDEV
RDWDM
RDWSYS
RE
REMOTE_SCHEDULER_AGENT
RENE
REPADMIN
REPORTOWNER
REPORTS
REPORTS_USER
REP_MANAGER
REP_OWNER
REP_USER
RESTRICTED_US
REVIEWADMIN
RG
RHX
RLA
RLM
RM1
RM2
RM3
RM4
RM5
RMAIL
RMAN
ROB
RPARKER
RRS
RTA
RWA1
RXA_ACCESS
RXA_DES
RXA_LR
RXA_RAND
RXA_READ
RXC
RXC_COMMON
RXC_DISC_REP
RXC_MAA
RXC_PD
RXC_REP
RXC_SERVLETSP
RXC_SERVLETST
SALLYH
SAM
SAMPLE
SAP
SAPR3
SARAHMANDY
SCM1
SCM2
SCM3
SCM4
SCOTT
SDAVIS
SDOS_ICSAP
SECDEMO
SEDWARDS
SELLCM
SELLER
SELLTREAS
SERVICECONSUMER1
SERVICES
SETUP
SH
SID
SIMADMIN
SITEMINDER
SI_INFORMTN_SCHEMA
SKAYE
SKYTETSUKA
SLIDE
SLSAA
SLSMGR
SLSREP
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
SPIERSON
SRABBITT
SRALPHS
SRAY
SRDEMO
SRIVERS
SSA1
SSA2
SSA3
SSC1
SSC2
SSC3
SSOSDK
SSP
SSS1
SST
STARTER
STRAT_USER
SUPERUSER
SUPPLIER
SVM7333
SVM7334
SVM810
SVM811
SVM812
SVM9
SVMB733
SVP1
SWPRO
SWUSER
SY810
SY811
SY812
SY9
SYMPA
SYS
SYS$UMF
SYS7333
SYS7334
SYSADM
SYSADMIN
SYSB733
SYSBACKUP
SYSDG
SYSKM
SYSMAN
SYSRAC
SYSTEM
SYS_ADMIN
TAHITI
TALBOT
TDEMARCO
TDOS_ICSAP
TDX
TEC
TEST
TESTCTL
TESTDTA
TESTPILOT
TEST_USER
THINSAMPLE
TIBCO
TIP37
TMS
TOPIC_WORKFLOW
TRA1
TRACESVR
TRAVEL
TRBM1
TRCM1
TRDM1
TRRM1
TSDEV
TSMSYS
TSUSER
TURBINE
TWILLIAMS
UDDISYS
ULTIMATE
UM_ADMIN
UM_CLIENT
USER
USER0
USER1
USER2
USER3
USER4
USER5
USER6
USER7
USER8
USER9
USER_NAME
USUARIO
UTIL
UTILITY
UTLBSTATU
VAERS_20030630
VAERS_20030830
VAERS_20030930
VAERS_20040228
VAERS_20040730
VAERS_20041231
VAERS_20050331
VAERS_20050831
VAERS_20051130
VAERS_20060430
VAERS_20060831
VAERS_20061231
VAERS_20070430
VAERS_20070630
VAERS_20070930
VAERS_20071231
VAERS_20080331
VAERS_20080630
VAERS_20080930
VAERS_20081231
VAERS_20090331
VAERS_20090630
VAERS_20090731
VAERS_20090831
VAERS_20090930
VAERS_20091031
VAERS_20091130
VAERS_20091229
VAERS_20100126
VAERS_20100226
VAERS_20100330
VAERS_20100428
VAERS_20100525
VAERS_20100609
VAERS_20100630
VAERS_20100731
VAERS_20100831
VAERS_20100929
VEA
VEH
VERTEX_LOGIN
VIDEO31
VIDEO4
VIDEO5
VIDEOUSER
VIF_DEVELOPER
VIGIBASE_2004Q1
VIGIBASE_2004Q2
VIGIBASE_2004Q4
VIGIBASE_2005Q1
VIGIBASE_2005Q2
VIGIBASE_2005Q3
VIGIBASE_2006Q1
VIGIBASE_2006Q2
VIGIBASE_2006Q3
VIGIBASE_2006Q4
VIGIBASE_2007Q1
VIGIBASE_2007Q2
VIGIBASE_2007Q4
VIGIBASE_2008Q1
VIGIBASE_2008Q2
VIGIBASE_2008Q3
VIGIBASE_2008Q4
VIGIBASE_2009Q1
VIGIBASE_2009Q2
VIGIBASE_2009Q3
VIGIBASE_2009Q4
VIGIBASE_2010Q1
VIGIBASE_2010Q2
VIGIBASE_2010Q3
VIGIBASE_4Q03
VIRUSER
VP1
VP2
VP3
VP4
VP5
VP6
VPD_ADMIN
VRR1
WAA1
WAA2
WCRSYS
WEBCAL01
WEBDB
WEBREAD
WEBSDM
WEBSYS
WEBUSER
WEBVDME
WENDYCHO
WEST
WFADMIN
WH
WHODD_2009Q3
WHODD_2009Q4
WHODD_2010Q1
WHODD_2010Q2
WHODD_2010Q3
WIP
WIRELESS
WKADMIN
WKPROXY
WKSYS
WKUSER
WK_PROXY
WK_SYS
WK_TEST
WMS
WMSYS
WOB
WPS
WSH
WSM
WWW
WWWUSER
XADEMO
XDB
XDO
XDP
XLA
XLE
XNB
XNC
XNI
XNM
XNP
XNS
XPRT
XS$NULL
XTR
YCAMPOS
YMS
YSANCHEZ
ZFA
ZPB
ZSA
ZX

1210 rows selected.

As you can see, there're 1210 usernames listed, which have the default password for the database to recognize.

According to the list, USER1, USER2, USER3, USER4, etc. who are very commonly used names in technology are also default usernames for an Oracle database.

All I can say is that if we don't look up the table, we will never know.

Who are Using Default Password?

To know who are using the default password currently, you may check this post: DBA_USERS_WITH_DEFPWD, How and Why.

Leave a Reply

Your email address will not be published. Required fields are marked *