Home » RDBMS Server » Security » How to find FGA, (Oracle 10g , linux 64 bit)
How to find FGA, [message #468823] Mon, 02 August 2010 04:53
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
We were receving ERROR ORA-01401: inserted value too large for column FROM our Application on table finance1 IN SCHEMA MOON.

To Audit we start Auditing on insert on this table by following


BEGIN
DBMS_FGA.ADD_POLICY(
object_schema => 'MOON'
,object_name => 'FINANCE1'
,policy_name => 'AUDIT_FINANCE1'
,audit_condition => NULL
,audit_column => 'COMMENTS'
,handler_schema => NULL
,handler_module => NULL
,enable => TRUE
,statement_types => 'INSERT'
,audit_trail => DBMS_FGA.DB_EXTENDED
,audit_column_opts => DBMS_FGA.ANY_COLUMNS
);
END;

After above audit started, there was ORA-01401 error generated

But the main problem is, when look at the table dba_fga_audit_trail, we are unable to find Error insert audit record because the size of field value are ok.


Previous Topic: Logon/off audit using Audit_Trail
Next Topic: virtual private database, Need Guidance
Goto Forum:
  


Current Time: Wed Apr 01 04:19:27 CDT 2020