How to add an additional attribute for all users by SQL.

Hello all,

I'd like to add one additional attribute for all users in Crowd.

Generally user has some attributes such as "lastAuthenicated", "passwordLastChanged" and so on.

Additionally I'd like to add one attribute to all users.

For example, attribute with name, "expiredDate" and value "1813945351209"

I think that SQL DB update is one of solution for me.

Please help me to have a sample SQL to use.

Regards, JJ

1 answer

0 votes

Hi @Jongho Jung! Thanks for clarifying with the "expiredDate" example.
Just to understand your setup:

Are your users stored in a Crowd Internal directory, or do they come from LDAP/AD? (With LDAP attributes you usually can’t inject values from the Crowd DB side.)
And do you need this "expiredDate" just as a custom info field, or should it also be used by Crowd for any logic (like authentication/expiry checks)?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.