Re: Oracle Audit aud$ vs Database Logon Trigger

From: Michael Dinh <mdinh235_at_gmail.com>
Date: Wed, 17 Oct 2012 20:28:34 -0700
Message-ID: <CAENwkM7fUgktzkfjyq_jKR6CrkD10nRf_Xz6Dxc7Pft9-KUPdg_at_mail.gmail.com>



I would use audit functionality for simplicity. AUDIT SESSION WHENEVER SUCCESSFUL; Query DBA_AUDIT_SESSION

Use DBMS_AUDIT_MGMT to manage.

HTH -Michael.

On Wed, Oct 17, 2012 at 7:32 PM, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> Hi
>
> Can someone help as what is best approach in term system performance and
> best practices for auditing. Requirements is only to check what user has
> not logon to the database in x number of days and create a report on daily
> basis. Requirement is to report user who has not logon to the database in
> last 180 days. So what is best practices like to use Audit command or
> Database Logon Trigger. Any help in providing any fact is highly appreciable
>
> TIA
> Sanjay
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 18 2012 - 05:28:34 CEST

Original text of this message