Database auditing
Hi everybody?
I do have a shema named PRACTICE with its own table named EMPLOYEES.
The table has fields: empid,fname,sex and age.
Their data types are varchar2,varchar2,varchar2 and number respectively.
The fields also held values LA,Lensa,F and 21 respectively.
Being on the sys schema, I defined a policy for auditing purpose as follow.
begin
dbms_fga.add_policy
(
object_schema =>'PRACTICE',
object_name =>'EMPLOYEES',
policy_name =>'AUD_EMP', audit_column =>'EMPID', audit_condition =>'EMPID=LA', statement_types =>'UPDATE' ); end; / When I tried to execute a statement- update employees set fname='Girma' where empid='LA', I got the following error message: ERROR at line 1: ORA-28138: Error in Policy Predicate. Please help me, I am waiting for your help. Thanks!
Software/Hardware used:
software
object_schema =>'PRACTICE',
object_name =>'EMPLOYEES',
policy_name =>'AUD_EMP', audit_column =>'EMPID', audit_condition =>'EMPID=LA', statement_types =>'UPDATE' ); end; / When I tried to execute a statement- update employees set fname='Girma' where empid='LA', I got the following error message: ERROR at line 1: ORA-28138: Error in Policy Predicate. Please help me, I am waiting for your help. Thanks!
Software/Hardware used:
software
ASKED:
May 25, 2010 12:44 PM
UPDATED:
May 25, 2010 4:05 PM
Answer Wiki:
I guess the error is here:
<pre>audit_condition =>'EMPID=LA', </pre>
which should be:
<pre>audit_condition =>'EMPID=''LA''', </pre>
As 'LA' is a string literal (not a column name) it needs to be enclosed in single quotation marks (escaped).
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
