Re: lock unused oracle user account

From: Arul Ramachandran <contactarul_at_gmail.com>
Date: Tue, 24 Mar 2009 19:23:39 -0700
Message-ID: <1c1a62990903241923w6e02f668we2969204707ea071_at_mail.gmail.com>



Hello ,

I am trying to find if 10g has a built-in feature to support this?

If you are aware could you please share any pointers.

Thanks, -Arul

On Thu, Feb 19, 2009 at 4:51 PM, Bradd Piontek <piontekdd_at_gmail.com> wrote:

> Yo could set up your own auditing with a AFTER LOGON database trigger and
> populate your own table to track logins by users. You could then write a
> package that will lock the accounts based on your criteria.
>
> Bradd Piontek
> "Next to doing a good job yourself,
> the greatest joy is in having someone
> else do a first-class job under your
> direction."
> -- William Feather
>
>
>
> On Thu, Feb 19, 2009 at 5:43 PM, Xu, Roger <Roger.Xu_at_dpsg.com> wrote:
>
>> Hi List,
>>
>> Without audit being turn on, how do we automate locking all users who
>> haven't logged on for 60 days and deleting them after 90 days unused?
>>
>> I have tried profile settings.
>>
>> Thanks,
>>
>> Roger Xu
>>
>>
>> http://www.drpeppersnapplegroup.com/about/corporate to learn more about
>> Dr Pepper Snapple Group's commitment to corporate social responsibility.
>>
>> Please be conscious of the environment and print this email only if
>> absolutely necessary.
>> This e-mail (including any attachments) is confidential and may contain
>> privileged information of Dr Pepper Snapple Group, Inc. and/or its
>> subsidiaries ("Dr Pepper Snapple Group"). If you are not the intended
>> recipient or receive it in error, you may not use, distribute, disclose or
>> copy any of the information contained within it and it may be unlawful to do
>> so. If you are not the intended recipient, please notify us immediately by
>> returning this e-mail to us at mailto:mailerror_at_dpsg.com and destroy all
>> copies. Any views expressed by individuals within this e-mail do not
>> necessarily reflect the views of Dr Pepper Snapple Group. This e-mail does
>> not constitute a binding offer, acceptance, amendment, waiver or other
>> agreement, unless the intent that an e-mail will constitute such is clearly
>> stated in the body of the email. Recipients are advised to subject this
>> e-mail and attachments to their own virus checking, in keeping with good
>> computing practice. Please note that e-mail r
>> eceived by Dr Pepper Snapple Group may be monitored in accordance with
>> applicable law.
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

-- 
Arul

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 24 2009 - 21:23:39 CDT

Original text of this message