Click HERE to see how Saviynt Intelligence is transforming the industry. |
11/03/2023 09:15 AM
Hi All,
Previously user's password was getting update with custom query job with the following query,
update users u set u.customproperty60 = CONCAT(UPPER(SUBSTRING(u.email, 1, 2)),SUBSTRING(u.employeeid, 1, 3),'$',(select floor(0+ RAND() * 10000)),SUBSTRING(u.email,2,2),'*') where
(u.customproperty60 IS NULL OR u.customproperty60='') AND u.USERKEY in (select a.userkey from arstasks a where a.endpoint= 5 AND a.SECURITYSYSTEM= 10 AND a.STATUS in (1,2) AND a.TASKTYPE=3 AND a.TASKDATE >= DATE_sub(NOW() , INTERVAL 1 day))
But now since the custom queries are being depreciated, therefore we have been suggested to use password policy as below,
If setting a password is needed and then sending this to target for an account, use password policy configs and set that policy at SS and EP to achieve this via update password.
So, we have configured a password policy in EIC, but unable to configure at SS & EP level. Please advise for the same.
Regards
Rishika
11/03/2023 10:00 AM
@srishika If Policy Scope is APPLICATION then navigate to admin>identity repository>Security system>Policy rule.
If the policy scope is User then This policy is invoked when a user password change or reset is initiated.
Refer the below doc for more information
Managing Password Policies (saviyntcloud.com)
11/03/2023 07:37 PM
Can you elaborate what is issue you are facing after attaching password policy ?