2011-09-01

Password expiring


Yet again...
A new 181 days ago created 11g database instance...
A software connection pool user is not allowed to connect to the database...

ORA-28002: the password will expire within 7 days
OR
ORA-28001: the password has expired 


select profile from dba_users where username = 'POOLUSER';



DEFAULT



create profile pool_profile limit PASSWORD_LIFE_TIME unlimited;



alter user pooluser profile pool_profile; 



select profile from dba_users where username = 'POOLUSER';



POOL_PROFILE

Posted by at

1 comment:

  1. RafuDecember 22, 2011 at 3:31 PM

    The more radical approach

    alter profile default limit password_life_time unlimited;

    ReplyDelete

Subscribe to: Post Comments (Atom)

About Me

My photo
I am Timo Raitalaakso. I have been working since 2001 at Solita Oy as a Senior Database Specialist. My main focus is on projects involving Oracle database. Oracle ACE alumni 2012-2018. In this Rafu on db blog I write some interesting issues that evolves from my interaction with databases. Mainly Oracle.