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