Notifications
Clear all

How do you set a users password to "password" on an platform instance via SQL?

   RSS

1
Topic starter

Need to reset a users password to "password" via SQL.

Topic Tags
1 Answer
1
Topic starter

An easy solution is simply to do this:

update sso_password_history set ssoph_user_password = '5f4dcc3b5aa765d61d8327deb882cf99'
where ssoph_ssopr_id = (select ssopr_id from sso_principal where ssopr_user_name = 'theusername')

You lose the history of older passwords, but often for the kind of users you are trying to do this for, that really doesn't matter.

If you want to only reset the most recent password AND reset the "too many failed login" flag:

update sso_password_history set ssoph_user_password = '5f4dcc3b5aa765d61d8327deb882cf99'
where ssoph_ssopr_id = (select ssopr_id
from sso_principal
where ssopr_user_name = 'THE_USERNAME') and ssoph_active_status_cd = 'Active';

update sso_principal set ssopr_active_status_cd = 'Active', ssopr_failed_logins_count = 0 where ssopr_user_name = 'THE_USERNAME';

© 2020 One Network Enterprises. All rights reserved. Privacy Policy