Re: How identify failed logon audit records
From: Karth Panchan <keyantech_at_gmail.com>
Date: Wed, 19 Nov 2014 12:06:03 -0500
Message-Id: <39CEE9FA-0C39-432D-8CFC-64A1FA32B43D_at_gmail.com>
Jeff
Date: Wed, 19 Nov 2014 12:06:03 -0500
Message-Id: <39CEE9FA-0C39-432D-8CFC-64A1FA32B43D_at_gmail.com>
Jeff
Look for 1017 value in RETURN_CODE column in v$xaml_audit_trail
Karth
Sent from my IPhone
> On Nov 19, 2014, at 11:59 AM, "Jeffrey Beckstrom" <JBECKSTROM_at_gcrta.org> wrote:
>
> We use XML OS files for our audit trail setting value. Currently, we audit selected user's SQL statements. I know want to turn on failed logon auditing. How can I identify these records in the v$xml_audit_trail table?
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> .
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 19 2014 - 18:06:03 CET