FGA on 10gR2 audit_condition => space
Hello
I'm trying to put and audit on a table (Jde), I want to trace users who insert or update a column with a space,
i tried
EXEC DBMS_FGA.ADD_POLICY (object_schema => 'PRODDTA',object_name => 'F43090',policy_name => 'TAB_F43090',audit_condition =>' ' ,audit_column =>'PCMCU',statement_types => 'UPDATE,INSERT',audit_trail => DBMS_FGA.DB_EXTENDED);
but it return error ORA-28138: Error in Policy Predicate
I also try audit_condition =>'PCMCU='' '''
but with the same result, what is the right syntax for space in audit_condition ?
Thank you
Noel
I'm trying to put and audit on a table (Jde), I want to trace users who insert or update a column with a space,
i tried
EXEC DBMS_FGA.ADD_POLICY (object_schema => 'PRODDTA',object_name => 'F43090',policy_name => 'TAB_F43090',audit_condition =>' ' ,audit_column =>'PCMCU',statement_types => 'UPDATE,INSERT',audit_trail => DBMS_FGA.DB_EXTENDED);
but it return error ORA-28138: Error in Policy Predicate
I also try audit_condition =>'PCMCU='' '''
but with the same result, what is the right syntax for space in audit_condition ?
Thank you
Noel
0