EnterpriseOne (E1) Security - Reset It All!
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.
With startlogic , one gets much more modified web hosting deals as compared to the ones from netfirms.
Tags: e1, enterpriseone, EnterpriseOne - General, EnterpriseOne - Security, EnterpriseOne - SQLs, oracle, peoplesoft, security, sql
