Re: Changing Password

Hai Gurus,

Yes,there is a way to change your password. Use this command.
ALTER USER USERNAME(SYSTEM OR OTHERNAME) IDENTIFIED BY PASSWORD; I tell you another trick for changing this passwords Suppose You dont know the pariticular Users Password ,you want to go inside the User ,
What you should do

1. Select username,Password from dba_users ;

2)Note down the particular User (the one you want to access) Password ,may be look like this '9FG90GAEWER' (Do not forget to notedown this password)

3)Then use ALTER USER USERNAME IDENTIFIED BY PASSWORD(new password)

4) then connect user/newpassword

4)Play with this Users data

5)Before exit keep the password as before ALTER USER USERNAME IDENTIFIED BY VALUES '9FG90GAEWER'(the one you noted before)

Regards.
Sul

• Original Message ----- From: B, Ravindra <Ravindra.B_at_compaq.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 19, 2000 11:29 AM Subject: Password

> Hi,
> One of my customer has forgotten the password for sys and system user.Is
> there anyway of
> changing the password.
>
> Ravindra
> --
> Author: B, Ravindra
> INET: Ravindra.B_at_compaq.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 19 2000 - 02:43:40 CDT