| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
