Re: how to expire an account

From: Li Li <>
Date: Thu, 8 Mar 2012 18:19:36 -0600
Message-ID: <>

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 <> 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:
> tel +32(0)3 451 23 82
> disclaimer:

Received on Thu Mar 08 2012 - 18:19:36 CST

Original text of this message