AnsweredAssumed Answered

Reset Passwords of all users

Question asked by vivek.gupta4 on Apr 4, 2014
Latest reply on Aug 26, 2014 by Luis.Palacios


There was this script since Clarity v8 till v12, using which we could set all users' passwords to be same as that of admin user.

update cmn_sec_users set pwd = (select pwd from cmn_sec_users where user_name='admin') where user_name not in ('admin', 'xog');

Is there any such script for v13.3 as well?

As per out set procedure, we refresh DEV and TEST from PROD every month. After that, we change passwords of all users in DEV using the above script so that we can check and simulate problems in DEV that the users are facing in PROD.

This was our first time after upgrade from v12.1.1 to 13.3 that we refreshed  the DEV and TEST from PROD. After we executed the above script, we are not able to login by any user except 'admin' and 'xog'.

Please let us know how to reset passwords of all users in v13.3