How to create a user with unlimited password expiry?

Hi ,

    For your info, need to create a user in FSM  

Hi @TatKhandM 

Above mentioned methods will do the work for you. From the DB level, you can try it out below.

1. Connect to the DB as sysdba
   SQL> connect sys/<password> as sysdba

2. Check the user belong to which profile
    SQL>SELECT username,PROFILE FROM dba_users;

3. Check the password policy for the profile( for example ‘default’)：
   SQL>SELECT * FROM dba_profiles s WHERE s.profile='<profile_name>' AND  resource_name='PASSWORD_LIFE_TIME';

4. Change the password expire period of the given profile
   SQL>ALTER PROFILE <profile_name> LIMIT PASSWORD_LIFE_TIME UNLIMITED;

5. Check the password expiry date for the confirmation
   SQL> select username, account_status, EXPIRY_DATE from dba_users where username='<user_name>';

Above change will affect all users assigned to the given profile. If this is not intended you can create a separate profile and assign it to the user and proceed with the changes

Eg:-

1. The following statement creates the “app_user2" profile with password limits values set:

CREATE PROFILE app_user2 LIMIT
   FAILED_LOGIN_ATTEMPTS 5
   PASSWORD_LIFE_TIME 60
   PASSWORD_REUSE_TIME 60
   PASSWORD_REUSE_MAX 5
   PASSWORD_VERIFY_FUNCTION verify_function
   PASSWORD_LOCK_TIME 1/24
   PASSWORD_GRACE_TIME 10;

2. Assign a profile to a user
   SQL> ALTER USER <user_name> PROFILE <profile_name>;

you can change the  oracle profile  ( e.g  DEFAULT) parameters as follows.

change the profile limit to unlimited.

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;

Check the password expiry date 

 
SQL> select username, account_status, EXPIRY_DATE from dba_users where username='TEST';
 
USERNAME                       ACCOUNT_STATUS               EXPIRY_DATE
------------------------------ ---------------------------- ---------
TEST                      OPEN                         UNLIMITED