Re: how to expire an account
- From: Li Li <litanli@xxxxxxxxx>
- To: "D'Hooge Freek" <Freek.DHooge@xxxxxxxxx>
- Date: Thu, 8 Mar 2012 18:19:36 -0600
I meant to lock the account completely... I was wondering if there's a
simple way to accomplish that... profile was the first I looked at,
and was hoping a combination of resource_type would do that but I
guess not. Thanks for your suggestion!
On Thu, Mar 8, 2012 at 6:13 PM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx> wrote:
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
