Sanjay, You could also check "created" column in dba_users for your "oracle" user and compare it to the date when the database was created. This will give you an indication whether "oracle" account was created when the db was created, or it was added later. Igor On Wed, Nov 11, 2009 at 8:44 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote: > Mark > > Yes it is correct as the DBs are mostly 10g and I check and found that > select password from dba_users where username='ORACLE' > EXTERNAL > > > ------------------------------ > *From:* "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx> > *To:* "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>; " > oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> > *Sent:* Wed, November 11, 2009 7:32:46 PM > *Subject:* RE: Database user Oracle > > First guess, is this an externally authenticated user? > > Select authentication_type from dba_users where username = ‘ORACLE’; > > > > > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sanjay Mishra > *Sent:* Wednesday, November 11, 2009 6:51 PM > *To:* oracle-l@xxxxxxxxxxxxx > *Subject:* Database user Oracle > > > > Does anybody know as what is the significance of "oracle" user in the > database. I checked the default user list on Pete Security URL and also > found that he listed this user in his one of the doc with some default > password. It is not visible in all database but only in few database and so > want to check as why it is created in the database. Google failed to bring > the result > > > > TIA > > Sanjay > > > >