Question

Expire time

Dear team

Is it possible to set never expire password for individually user? 

My customer calls odata creatio service and they need to have a user with password that Never expire.

All users have expire password, but the service account used for odata calls should not expire. 

Like 0

Like

5 comments

Hi Stefano,

 

I had the same issue, here: https://community.creatio.com/questions/password-validity-term

 

I used this sql:

 

Update SysAdminUnit set PasswordExpireDate = NULL

 

to set expire date for every user to null, you could use a where clause for your odata user.

Watch out for the " Password validity term " system setting as I'm not sure if it is diferent then 0, it will rewrite the expire date.

 

Rgds,

Luis

Dear Stefano,

 

If you set MaxPasswordAge to 0 the password will never be expired.



Best regards,

Angela

Thank you Angela and Luis.

 

I need to set PasswordExpireDate to null for one user only, the user used as the service account to make the calls to the odata web service.

 

@Angela Do you suggest me to use the sql script console addon to do it in the cloud environment or is it better to ask the support team to do it?

Stefano Bassoli,

SQL script console addon is perfect for such requests. It should not be used only if your query is executed for more than 30 seconds.

 

Best regards,

Angela

thank you

 Angela

Show all comments