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.
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?