RE: Password Changes

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Fri, 07 Dec 2001 10:30:30 -0800
Message-ID: <F001.003D7B79.20011207101705@fatcity.com>

If you have an old full export of the database, you can find in the beginning of the file the users definitions like: Create user <USER> identified by values '<some value>'

Search for the user you're interested in and get the encrypted password '<some value>'
and run this command:

Alter user <USER> identified by values '<some value>' ;

Regards,

Waleed

-----Original Message-----
Sent: Thursday, December 06, 2001 7:37 PM To: Multiple recipients of list ORACLE-L

It can be seen in dba_users. The table is sys.user$.

Once you've changed it, the old value is gone for good.

Jared

                    "Burton, Laura

                    L."                  To:     Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <BurtonL_at_prism       cc:

                    plus.com>            Subject:     Password Changes

                    Sent by:

                    root_at_fatcity.c

                    om

 

 

                    12/06/01 10:29

                    AM

                    Please respond

                    to ORACLE-L

When you alter a user's password, what table does it update?

I need to 'restore' a password for a user back to what it was before I changed it, but do not know what it was.

Any ideas?? Can this be done?

Thanks,
Laura

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------