Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: Is there any way to change the INTERNAL password?
Michael Spellbrink wrote:
> "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.
> anyway, couldnt you just drop the tablespaces ?
> or even opening the controlfiles in an editor?
>
> hth, michael spellbrink
Internal is NOT a user in Oracle. The user is SYS.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Aug 26 2003 - 14:36:19 CDT