We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Anyways to know the user password ? — Vertica Forum

Anyways to know the user password ?

SK21SK21 Vertica Customer ✭
in General Discussion

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.

Answers

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    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.

  • DaveTDaveT Vertica Employee Employee

    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.

  • SK21SK21 Vertica Customer ✭

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...