RE: how to expire an account
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.
Oracle Database Administrator
tel +32(0)3 451 23 82
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Li Li Sent: vrijdag 9 maart 2012 0:59
Subject: how to expire an account
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?
http://www.freelists.org/webpage/oracle-l Received on Thu Mar 08 2012 - 18:13:53 CST