This content has been marked as final. Show 3 replies
Maureen Blackford wrote:Look at PROFILEs.
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
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.
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
Later on, the johndoe OS user connects to the DB:
SQL> create user ops$johndoe identified externally;
SQL> connect /