I welcome Steve Pitcher‘s suggestion from this Linkedin Post: a simple SQL statement to get the list of users with default passwords who haven’t been SIGNON for some time:
select * from qsys2.user_info where user_default_password = 'YES' and previous_signon <current date - 60 days and status = '* ENABLED';
Of course, we can also check all users with default passwords and not limit ourselves to those who have not logged in for 60 days.
The advice is to disable these users or to set a non-default password with CHGUSRPRF.
Have you found any? I do … more than one!
--- Roberto De Pedrini Faq400.comDebugging functions with Visual Studio Code have been available for some time but this new version 2.10.0 simplifies the handling…
Two and a half years after my post Transferring objects with ObjectConnect and Enterprise Extender, I finally got around to…
With a little trick even a simple SELECT statement can execute any system command! Let's see how to do that...
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer
View Comments
https://www.rpgpgm.com/2021/07/changing-user-profiles-using-sql.html