RE: password

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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Bob Metelsky [mailto:bmetelsky_at_cps92.com]
> 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: Rich.Jesse_at_qtiworld.com

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