on a TEST database.... go ahead and try that you can't update dba_users that way
--- Bob Metelsky <[EMAIL PROTECTED]> wrote: > > 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 > > > > Yes, but that is not what he asked. > > > > Try logging in with the value from dba_users. ;) > > > > Jared > > > > > > > > > > > > "Bob Metelsky" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 12/17/2002 10:14 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject: RE: password > > > > > > How about > > > > select username, password from dba_users; > > > > USERNAME PASSWORD > > ------------------------------ ------------------------ > > SYS D4C5016086B2DC6A > > SYSTEM D4DF7931AB130E37 > > > > This is part of the becomeuser script where you can change > > and then reset the password for a user > > > > spool C:\reset.sql > > > > select ' alter user &&1 identified by values ' ||''''|| > > password||''''||' profile '||profile||';' > > from dba_users where username = upper ('&&1') ; > > spool off; > > > > > > > > bob > > > > > > > > > > You can't. > > > > > > > > > > > > > > > > > > > > > "faisal ahmad" <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 12/16/2002 08:09 PM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > > > <[EMAIL PROTECTED]> > > > cc: > > > Subject: password > > > > > > > > > how can a dba see the password of a user. > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Bob Metelsky > > 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). > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > 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). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bob Metelsky > 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). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).