Time To Change Your Password « E1 Tips E1 Tips

Sep/08

Time To Change Your Password

by Stewart Schatz under EnterpriseOne - Security, EnterpriseOne - SQLs

We have our passwords set to expire every 90 days.

Sometimes there are user IDs that you don’t want to change but don’t really want them to show up on the audit report as not having an expiration period.

Here is a SQL statement that can help you:

UPDATE SY811/F98OWSEC
SET SCSECLST=<numeric date> 
WHERE SCUSER='<UserID>'

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }