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