Last Updated on 29 July 2022 by Roberto De Pedrini
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!
Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more
DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more
Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more
Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more
https://www.rpgpgm.com/2021/07/changing-user-profiles-using-sql.html