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. Regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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? TIA, -Li -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l