Dobronte
asked on
Substitute FGA functionality in Oracle 9iR2
Hi!
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.