Re: lock unused oracle user account

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Thu, 19 Feb 2009 17:51:41 -0600
Message-ID: <e9569ef30902191551r2390f2cds2bc5dce78a8c16d0_at_mail.gmail.com>

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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 19 2009 - 17:51:41 CST