We wanted to make a whole sql statement capture solution with FGA in a datawarehouse system to audit user actions on an Oracle9iR2 RDBMS on HP UNIX. We heard, that there is serious problem with FGA in this version and the patch which will fix it will come out only in 1 or 2 months, but our customer wants to use this patch only after 3 months more testing period. For this 5 months period we need a solution which lets us to capture the whole sql statement of users who selects predefined tables (predefined columns). We need the time, dbuser, osuser, client and sql statement information at least (table name is also preferred).
Thank you for your help