Home » RDBMS Server » Security » Password
Password [message #72644] Wed, 13 August 2003 22:48 Go to next message
NG
Messages: 18
Registered: March 2003
Junior Member
Is it a way of decrypt the user password cause password are stored in encrypted format in the oracle database...
I am a administrator and wish to have a list of all users and password...
Any help is much appreciated..
Thanks
Re: Password [message #72646 is a reply to message #72644] Thu, 14 August 2003 06:50 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i dont think so.
a password is supposed to be encrypted AT_ANY_CASE.
and passwords are NOT SUPPOSED TO BE DECLARED even to the administrator.
If you have the administrative rights, you can always access the objects owned by other user.
if you want to login as the other user and do some work as that user we have custom code that is equalent to 'su' in unix ( works only from a dba account to non dba acccount).
to start with you can always , capture the passcode ,
change it to temp_passcode ,
login as the user with temp_passcode,
do ur business,
logoff and reset the passcode to wahtever it is.
THE ORIGINAL PASSWORD IS NOT REVELAED AT ALL.

this link, shows how to do this step by step.
else
our 'su' proc does the same in one step.

http://orafaq.com/faqdbase.htm#BECOMEUSER

Previous Topic: Reviewing Roles
Next Topic: Changing user's Password
Goto Forum:
  


Current Time: Mon Nov 23 16:41:40 CST 2020