Re: URGENT: Is there any way to change the INTERNAL password?

"DJ" <nospamplease_at_goaway.com> wrote in message news:lHQ2b.5307$L15.734_at_newsfep4-winn.server.ntli.net...
>
> "Maximus" <asdfasdasd_at_eqeqweqwe.com> wrote in message
> news:sYO2b.846042$ro6.16772255_at_news2.calgary.shaw.ca...
> > "Michael Spellbrink" <michaelspellbrink_at_yahoo.de> wrote in message
> > news:638121fa.0308261108.270beaef_at_posting.google.com...
> > > "Dave" <JustShutUp_at_azwhole.com> wrote in message
> > news:<bifsma$4d5e$1_at_netnews.upenn.edu>...
> > > > Hi Group,
> > > > I have inherited a database with an INTERNAL account whose
password
> > was
> > > > changed and never documented. I can logon to the database as SYS
and
> > SYSTEM
> > > > and another account that has full DBA privileges. I need to delete
> the
> > > > database. Can I delete the database without the INTERNAL password
> (the
> > > > database config asst won't let me) or is there a way to change this
> > > > password?
> > > >
> > > > Dave
> > >
> > > if you have sysdba authority you might be able to change the
> > > 'INTERNAL'
> > > password in a way similar to this:
> > >
> > >
> > > alter user internal identified by values 'tehs00k';
> > >
> > > and then connect using 'tehs00k' as password, i never tried it with
> > > the user INTERNAL, but it's worth a try.
> > > please post the current environment as it may helping finding some
> > > other way.
> >
> > Nay, won't work. INTERNAL is the old method of authenticating SYSDBA's
> via
> > password file authentication, the username only exists in the password
> file
> > and not the database. The only way to reset the INTERNAL password is to
> use
> > orapwd, which also resets SYS (which is the default SYSDBA account) to
the
> > same password.
> >
> > > anyway, couldnt you just drop the tablespaces ?
> > > or even opening the controlfiles in an editor?
> > >
> > > hth, michael spellbrink
> >
> >
>
> dont need a password file to use internal

depends on your authentication method Received on Tue Aug 26 2003 - 17:22:49 CDT