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
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
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

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

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: Sun Sep 26 19:27:07 CDT 2021