RE: Can password be accessed from data dictionery

Yes, But you don't see the password, you can apply the password.
use following command:
select
'ALTER USER '||USERNAME||' IDENTIFIED BY VALUES '
||''''
||Password||''''
||';' from DBA_USERS
where Username = UPPER('&username');

ALTER USER XXXXX  IDENTIFIED BY VALUES '41E6E0F9E4A7D7C1';

-----Original Message-----
From: Vipin Nehra [mailto:[email protected]]
Sent: 2003年2月26日 16:23
To: Oracle
Subject: [oracle] Can password be accessed from data dictionery


Is it possible to access the password from data dictionery.


Vipin nehra
****************DISCLAIMER*****************  This  message  and  any
attachments (hereinafter referred to as the 'mail content')  is  intended
solely  for  the  addressee. The 'mail content' is confidential  and may be
privileged and is also prohibited from disclosure. Access,  use,  copying,
distribution  or  re-use  of the 'mail content' by anyone  except  the
addressee is unauthorized. If you are not the intended addressee,  please
destroy  all  copies  of  the  'mail  content'  in your possession and also
delete the same from your computer. Any views expressed in  the  'mail
content' are those of the individual sender except where the sender,  with
due  authority of Jyoti Structures Ltd., specifically states them  to  be
the  views  of Jyoti Structures Ltd. Nothing contained in the 'mail
content'  is  capable  or  intended  to  create  any legally binding
obligations  on  the  sender,  Jyoti  Structures  Ltd.  The  sender,  Jyoti
Structures  Ltd., accepts no responsibility, whatsoever, for loss or damage
from the use of the 'Said Information' including damage from viruses.
****************************************************



---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].