AW: Help with passwords

Hi Marco,

Following select will generate a alter user with old password. After generating SQL you can change password of a user. With the generated SQL ypu can set password bak to original one.

SELECT          'alter user ' || username ||
                        ' identified ' ||
                        DECODE(password, NULL, 'EXTERNALLY', ' by values '
|| '''' || password || '''') ||';'
FROM            dba_users
ORDER BY        username;

regards

Volker Schoen
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Ursprüngliche Nachricht-----
Von: G.L.Alink_at_civ.utwente.nl [mailto:G.L.Alink_at_civ.utwente.nl] Gesendet: Mittwoch, 24. Oktober 2001 16:10 An: Multiple recipients of list ORACLE-L Betreff: Help with passwords

Hi all,

I've got a little question, which i can't find simply on metalink. I've got one user with a not know password and i want to temporary change it;s password. I know it is possible to save the hex-key in dba_users. But how can i change it back to that hex-key?

I need temporary this user account and can change the password, but i want to change it back to the original.

Thx anyway,
Marco

> Marco Alink
> Systeem- en databasebeheerder, Centrum voor Informatievoorziening,
> Universiteit Twente, Postbus 217, 7500 AE Enschede
> telefoon: 053 - 489 2628, fax:053 - 489 2383, http://www.utwente.nl/civ
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: G.L.Alink_at_civ.utwente.nl

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: Schoen Volker
  INET: v.schoen_at_inplan.de

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).