Is their anyway to know the password of a user in vertica who has forgotten and doesn't wants it to
change. Looked at the passwords system table but it has in encrypted format.
Question
Anyways to know the user password ?
+2
+2The password is not stored anywhere in the database in plain text. What you see in the database is a one way hash value generated by either the MD5 or SHA512 security algorithm.
An administrator can alter the user to supply a new temporary password and also use PASSWORD EXPIRE so the user will be forced to immediately reset it.
+2@Jim_Knicely yes it seems like in md5 format. See the output of password auditor attached.
I tried many internet tools to convert md5 to plain text but got no luck.
Any ways to do that?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
