Default PASSWORD_LIFE_TIME Set To 180 Days For Siebel Remote Users (Doc ID 2456305.1)

Last updated on OCTOBER 06, 2018

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Local database for some siebel remote users has the password life time parameter set to 180 days

EXPECTED BEHAVIOR
-----------------------
Local database for all siebel remote users should have password life time parameter set to unlimited

STEPS
-----------------------

1) Connect in the Oracle XE local database using sqlplus
2) Execute the sql below to verify the information for the siebel user

SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE FROM DBA_USERS;

1) Execute the sql below to verify the profile and the life time parameter

SQL> SELECT * FROM DBA_PROFILES;

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.