Password Expiration - Setting up an Event

  • 61 Views
  • Last Post 5 weeks ago
Greatdi1 posted this 26 September 2019

Good Morning,

 

Has anyone successfully set up an event that will send an email to the users when their password is about to expire? 

 

Order By: Standard | Newest | Votes
chana05 posted this 16 October 2019

The notification comes only in the application, but you can create a small program outside of IFS to poll the table/view and send out emails. 

Greatdi1 posted this 23 October 2019

Is there any way I could get your program so I do not have to recreate the wheel?

 

Thanks!

ERPTechServ posted this 5 weeks ago

You could create a database scheduled task to look at the DBA_USERS Oracle view and check the expiry against SYSDATE, then use the Oracle DB to email the user.

Some code to get you started.

 

SELECT USR.USERNAME, USR.EXPIRY_DATE, COMM.VALUE AS EMAIL_ADDRESS

FROM DBA_USERS USR

INNER JOIN IFSAPP.COMM_METHOD COMM

ON COMM.IDENTITY = USR.USERNAME

AND COMM.METHOD_ID_DB = 'E_MAIL'

WHERE usr.ACCOUNT_STATUS = 'OPEN'

 

AND usr.EXPIRY_DATE IS NOT NULL;

 

Cheers

Rob.

Greatdi1 posted this 5 weeks ago

Thank you!

Close