Re: Auditing user profile changes: Noting when a password is changed from *NONE to something else.

yes, do you own select for the before image :
SELECT User_Name
,Status
,Pwdchgdat
,Spcaut
,Lmtcpb
,No_password_indicator
FROM Qsys2.User_Info;

store that in some temp area
then compare to the same SQL after the change event happens

the password from *none to a password(or vice versa) is in the "No_password_indicator" field

Bryan


Rob Berendt wrote on 7/25/2019 10:42 AM:

By grabbing a before/after image I would have to do my own select from user_info right? I looked at those formats and it's not like a trigger with before/after images included.
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/apis/XCHGUP.htm#HDRCHGFMT

This might help with tracking LMTCPB but not the password changed from *NONE as I don't believe that select will return the password.

Trying to find a solution but I've also added this rfe:
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=134842


Rob Berendt