RE: how to expire an account

From: D'Hooge Freek <>
Date: Fri, 9 Mar 2012 01:13:53 +0100
Message-ID: <>

Do you mean to expire the password or to just lock the account? The first can be done via profiles (password_life_time) for the other I think you will need to create a scheduler job that checks the user creation times to verify if it has expired or not. If so, it issues an alter user account lock statement.


Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

-----Original Message-----

From: [] On Behalf Of Li Li Sent: vrijdag 9 maart 2012 0:59
To: oracle-l
Subject: how to expire an account

Hi, List,

I wonder how to expire an account after certain days? I looked at profile and all the password resource_type doesn't seem to accomplish that purpose. Anyone suggestion or comments?


-- Received on Thu Mar 08 2012 - 18:13:53 CST

Original text of this message