Isolate System Users from Password initialization

[Former Member]

Hi All,

We want to initialize the passwords for all the users after every 90 days, BUT we DO NOT want to initialize the passwords for system users like DDIC,SAP*,J2EE_ADMIN etc. We know that we can initialize the passwords by setting the parameter in the intance profile, but i need to know how we can initialize all the users BUT system users.

Regards,

[debasissahoo · Accepted solution]

Hi,

if login/password_expiration_time is set then all DIALOG users will be affected. No exception to any DIALOG user.

Only exception is to users of SYSTEM and SERVICE type.

Regards,

Debasis.

[Former Member · Accepted solution]

Thanks Debasis.

What about using a script at the DB level? Can this resolve the issue? There is a field in USR02 - PDWSTATE, can we make it -2 at the DB level ? Can we have any alternative.

[Former Member]

We are writing a DB script to run every 90 days and exclude the system users