[midPoint] How to en-/decrypt passwords with the DatabaseTableConnector

[Ch. Olbricht]

Hi Community,

midpoint is using a keystore for passwords, the ldap and  the AD 
connector en-/decrypt passwords, but:

    How to  en-/decrypt passwords with the |DatabaseTableConnector to a
    |postgresql table?

As a SQL sample for postgresql:

    encrypting:    SELECT
    |p||gp_sym_encrypt(cleartext_passwort,'secret-key')::TEXT AS
    encrypted_password;|
    |||decrypting: SELECT pgp_sym_decrypt(||encrypted_password||::BYTEA,
    '||secret-key||') AS ||cleartext_passwort||;|||
    ||

|
D|oes anyone knows, how to encrypt passwords with SQL in postgres and 
decrypt these credentials in a |DatabaseTableConnector resouce?||


|Kind Regards
Christian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20250822/b347cd23/attachment.htm>