Anyways to know the user password ?
SK21
Vertica Customer ✭
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.
0
Answers
The 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.
@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?