RE: how to expire an account

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "litanli@xxxxxxxxx" <litanli@xxxxxxxxx>, oracle-l <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 9 Mar 2012 01:13:53 +0100

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
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82

-----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?



Other related posts: