| knowing password - possible?? [message #132769] |
Tue, 16 August 2005 01:49  |
vgs2005
Messages: 123
Registered: April 2005
|
Senior Member |
|
|
|
Say DBA_XXX is a user which has dba rights. Earlier, it created user ABC. ABC, however, changed its password. IS it possible for DBA_XXX to know it? if so, how? thanks in advance...
|
|
|
|
| Re: knowing password - possible?? [message #132770 is a reply to message #132769] |
Tue, 16 August 2005 01:54  |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
No u can't do it.
But u can change the password of ABC again as u desire, without expiry option,so that the password remain same always,ofcourse if the user itself will not change it later.
regds
dinesh
|
|
|
|
| Re: knowing password - possible?? [message #132809 is a reply to message #132770] |
Tue, 16 August 2005 05:32 |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
There's a nice little trick to connect to an existing your without knowing or permanently changing the password. It's using the "ALTER USER xxx IDENTIFIED BY VALUES 'the_encrypted_password'" syntax.
You can find it here.
But passwords are stored as a hash in Oracle. There's no reverse algorithm for it, i.e. you can't make it human readable again. Oracle just compares the hashes when you log on.
MHE
[Updated on: Tue, 16 August 2005 05:34] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
