Unfortunately, Bob will know because he won't be able to login anymore after the changes. The password has now changed to 'D4C5016086B2DC6A'. Perhaps you're looking for the BY VALUES clause?
Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Bob Metelsky [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: password > > > > Yes that's rite I cant use D4C5016086B2DC6A as the password > > But... > > I can > SQL> alter user bob identified by newpassword ; > > Log on as bob and make any changes I want then... > > SQL> Update dba_users set password = 'D4C5016086B2DC6A' where > user = bob > ; > > Bob doen not know his account has been modified > > I know that's not what he asked but... I havent threw in my 2cts in a > while ;-> > And this could prove useful from time to time.... > > > bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
