Password will expire after 60 days

[Former Member]

Password will expire after 60 days and the user has to mandatory change it.

Please help how I set it.

Thanks,

Manas

[Former Member · Accepted solution]

Hi Manas,

Execute the statement, below;

SQL> alter profile default limit password_life_time UNLIMITED;

Best regards,

Orkun Gedik

[volker_borowski2 · Accepted solution]

Hi,

changing the Oracle DEFAULT profile is not recommended anymore.

You should use SAPUPROF.according to note 1519872.

The old note 951167 still has some SQL statements, that might be usefull (to unlock the user,...),

but since the DB-User should have SAPUPROF assigned, it is not usefull anymore

to modify the Oracle DEFAULT profile. SAPUPROF is already adjusted to not expireing passwords.

To change the password, you should use brtools:

brconnect -u / -f chpass -o <SAP schema user>

Volker

[Former Member]

Please tell me where user must to change password: in SAP or in Oracle? And what user must to do that?

Regards

Roman

[former_member266290]

Hi Roman,

You will have to use OS user orasid ( in case of UNIX) or sidadm (in case of Windows).

As suggested by Volker refer Note 1519872 - SAP Database User Profile SAPUPROF for

detailed steps.

Regards

[Former Member]

Hi Vijajy,

thank for your answer. But I asked this question to Manas Sahoo.

Regards

Roman