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@xxxxxxxxx> 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@xxxxxxxx> 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@xxxxxxxx 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. >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > -- Arul