3 Replies Latest reply on Jul 30, 2009 5:34 PM by Uwehesse-Oracle

    Oracle 11G - set id password to not expire

    712514
      Hello, I've created an Oracle 11G database. The default on passwords is to expire every 180 days. I need to create an account that batch processes can use (for application code) which will not expire. How do I set a password on a user id to not expire? Maureen
        • 1. Re: Oracle 11G - set id password to not expire
          jgarry
          [Let me google that for you.|http://lmgtfy.com/?q=oracle+11g+password_life_time+unlimited]
          • 2. Re: Oracle 11G - set id password to not expire
            EdStevens
            Maureen Blackford wrote:
            Hello, I've created an Oracle 11G database. The default on passwords is to expire every 180 days. I need to create an account that batch processes can use (for application code) which will not expire. How do I set a password on a user id to not expire? Maureen
            Look at PROFILEs.

            And rethink your goal. The longer a password is allowed to live, the more opportunity for it to become exposed. If you care at all about database security, never allow a password to have unlimited life. Our end users have 180 life, my internal administrative passwords have 90 life.
            • 3. Re: Oracle 11G - set id password to not expire
              Uwehesse-Oracle
              If you logon at the server on which your oracle database runs on for your batch job, you could use OS authentication for the related DB user. That way the database does not store or expire a password. Instead, the password maintenance rules of the OS users apply.

              If there is for example an UNIX OS user like johndoe, you would say
              SQL> create user ops$johndoe identified externally;
              Later on, the johndoe OS user connects to the DB:
              SQL> connect /
              Kind regards
              Uwe

              http://uhesse.wordpress.com