Oracle Auditing by User

From: indytoatl <indytoatl_at_gmail.com>
Date: Fri, 22 Apr 2011 18:36:59 -0700 (PDT)
Message-ID: <6e6ef861-e499-4169-a50c-77fb3819fa3c_at_l6g2000vbn.googlegroups.com>

I am trying to audit select statements on a column for everyone except JohnDoe who works in the HR dept. How do I create the correct audit_condition??

BEGIN
    DBMS_FGA.ADD_POLICY(

         object_schema => 'HR'


        ,object_name => 'EMPLOYEES'

        ,policy_name => 'PAYROLL_INFO'

        ,audit_condition => 'DBUser NOT = 'JohnDoe'

        ,audit_column => 'SALARY'

        ,handler_schema => NULL

        ,handler_module => NULL

        ,enable => TRUE

        ,statement_types => 'SELECT'

        ,audit_trail => DBMS_FGA.DB_EXTENDED

        ,audit_column_opts => DBMS_FGA.ANY_COLUMNS

    );
END;

/ Received on Fri Apr 22 2011 - 20:36:59 CDT