2 Replies Latest reply: Sep 15, 2009 1:56 AM by Anurag Tibrewal RSS

    expired user password - oracle 11g

    715772
      hello,

      how can I turn off stupid user password expiration ?

      I have used this sql:

      ALTER PROFILE DEFAULT LIMIT
      FAILED_LOGIN_ATTEMPTS UNLIMITED
      PASSWORD_LIFE_TIME UNLIMITED;

      How can I check if user password will not expire ?

      How can I check if stupid default password expire option is turned off ?

      How can I check when user password will expire ?

      How can I disable passsword expiration for specified user ?



      p.s. sorry for word "STUPID", in my opinion this option generate more problems (big and huge) than benefits. houpfully server still keeping authentication sessions

      Edited by: Dlugasx on Sep 14, 2009 11:40 PM
        • 1. Re: expired user password - oracle 11g
          asifkabirdba
          Your SQL is ok. Check with these two parameters will show you the time when user password will expire. Check the profile values when a password will expire. If you assign user A,B.C to a profile which password will expire after 1o days then password of A,B,C will be expired after 10 days.

          Regards
          Asif Kabir
          • 2. Re: expired user password - oracle 11g
            Anurag Tibrewal
            Hi,
            How can I check if user password will not expire ?
            
            select LIMIT from dba_profiles where RESOURCE_NAME ='FAILED_LOGIN_ATTEMPTS' 
                 and PROFILE = (select profile from dba_users where username = 'SCOTT');
            Replace scott with user you are interested in , if it is unlimited or no rows selected it means it wont expire.
            How can I check if stupid default password expire option is turned off ?
            same as above
            How can I check when user password will expire ?
            same as above
            How can I disable passsword expiration for specified user ?
            
            select profile from dba_users where username = 'User you are interested in';
            
            ALTER PROFILE <name of the profile from above query> LIMIT
            FAILED_LOGIN_ATTEMPTS UNLIMITED
            PASSWORD_LIFE_TIME UNLIMITED
            Regards
            Anurag Tibrewal