Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Anyways to know the user password ?

SK21SK21 ✭
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 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 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 ✭

    @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
Heading 1Heading 2
QuoteCodeSpoiler
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 ...

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.