Re: how to expire an account
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_at_uptime.be> 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.
> Freek D'Hooge
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> disclaimer: www.uptime.be/disclaimer