Re: How identify failed logon audit records

  • From: Karth Panchan <keyantech@xxxxxxxxx>
  • To: "JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>
  • Date: Wed, 19 Nov 2014 12:06:03 -0500

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@xxxxxxxxx> 
> 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
>  
> .

Other related posts: