EnterpriseOne (E1) Security – Reset It All!
Read Time:52 Sec
The organization that I work for has a SOX requirement that all passwords need to be changed every 90 days. I think this is pretty common. It matches what many people have for their network password policy.
Anyway, I put together a quick SQL to verify that all of our users are required to change their password every 90 days:
select count(*) from sy811/f98owsec where SCSECFRQ 90
Then, I had to figure out what were the IDs that were not set for 90 days:
select * from sy811/f98owsec where SCSECFRQ 90
Now, you know the records that may need to be fixed.
WARNING: There is a record in the F98OWSEC that looks pretty strange. The SCUSER value is "*POLICY". This record is used to store the Global Password Policy values. Most of the information is in this record is stored in the SCSRVBLOBA field.
Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards
With startlogic , one gets much more modified web hosting deals as compared to the ones from netfirms.
Za9wkN Wow! Great thinking! JK