I've encrypted password in db2 cloud. However, how to decrypt it?

Question

Any idea 🤔

Answer 1

I don't have experience with DB2, but as I understand it (in practice), passwords are better off be hashed rather than be encrypted. This is because hashing algorithms are supposed to generate non reversible result, whereas encrypt (usually) has a counter decrypt method.

Try to search the net for DB2 password hash methods and techniques. I'm pretty sure you'll find some good tutorial and examples 👍

Answer 2

Aha. Thanks I'll look for it.

Answer 3

Encrypt or hash? hash is technically irreversible IIRC.
Since you're the one who's encrypting it, shouldn't you know already the way to decrypt it?
Which method you used to do it can you tell?

Answer 4

The thing is I was trying to create a database table and I didn't want to reveal passwords of the workers. So, I Googled to encrypt it in db2 so
I did as
encrypt (('xuiokb') , 'quiojhkkbb')
That's why,
Is there any way to not show the password in database table?