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" <faisalahmad4u_at_hotmail.com>
> Sent by: root_at_fatcity.com
> 12/16/2002 08:09 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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: bmetelsky_at_cps92.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).