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.
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
Other related posts:
