I believe it works always if you have user with dba privilegies and so have
access to dba_users. What is the problem?
>
>
> that only works if you don't use the password aging
> functions in the profile
>
>
> >From: "Shevtsov, Eduard" <EShevtsov_at_flagship.ru>
> >To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>,
> >carmichr_at_hotmail.com
> >Subject: Re: SYS password is not known (Oracle for NT)
> >Date: Tue, 12 Dec 2000 22:48:51 +0300
> >
> >Hi Rachel and List,
> >
> >from time to time I need do some specific SYS's job (for
> instance run any
> >rdbms/admin/*.sql ) I have dba user but haven't sys's
> password and time to
> >wait while our busy dba 'wake up' (we are at development
> side). Look, it
> >works for sys also. You need 5sec only to change the sys's
> password back.
> >
> >
> >SQL> select password from dba_users where username='SCOTT';
> > PASSWORD
> > -----------------------------
> > F894844C34402B67
> >
> >SQL> alter user scott identified by lion;
> > User altered.
> >
> >SQL> connect scott/lion
> > Connected.
> >
> >REM Do whatever you like...
> >
> >SQL> connect system/manager
> > Connected.
> >
> >SQL> alter user scott identified by values 'F894844C34402B67'; User
> >altered.
> >
> >SQL> connect scott/tiger
> > Connected.
> >
> >Regards,
> >Ed
> >
> >
> > > If you REALLY need to log in as SYS (and I agree with
> Joe, you shouldn't
> >be)
> > >
> > > you can change the password:
> > >
> > > log into sqlplus as SYSTEM (you said you have this password, yes)
> > >
> > > then run:
> > >
> > > alter user sys identified by <new password>;
> > >
> > > and you will have changed the SYS password... no need to
Received on Wed Dec 13 2000 - 00:09:11 CST
