Re: Database user Oracle

  • From: Igor Neyman <igor.neyman@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Wed, 11 Nov 2009 21:02:51 -0500

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
>
>
>
>

Other related posts: