E1 Tips The Tips & Tricks of a CNC Administrator on Oracle JDEdwards EnterpriseOne

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.

pf button EnterpriseOne (E1) Security   Reset It All!
evernote EnterpriseOne (E1) Security   Reset It All!digg EnterpriseOne (E1) Security   Reset It All!share save 171 16 EnterpriseOne (E1) Security   Reset It All!

One Response to “EnterpriseOne (E1) Security – Reset It All!”

  1. Za9wkN Wow! Great thinking! JK

Leave a Reply