Re: how to expire an account
From: Li Li <litanli_at_gmail.com>
Date: Thu, 8 Mar 2012 18:19:36 -0600
Message-ID: <CAN-mCbOCPP2WYyDr-5+HYk0=6bj5hH-Rnjtjg1s0VpRKFrSK5A_at_mail.gmail.com>
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!
Date: Thu, 8 Mar 2012 18:19:36 -0600
Message-ID: <CAN-mCbOCPP2WYyDr-5+HYk0=6bj5hH-Rnjtjg1s0VpRKFrSK5A_at_mail.gmail.com>
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.
>
> Regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 08 2012 - 18:19:36 CST