Auditing select statements to a specific table?

[ajhull]

I am aware of FGA, but FGA will not tell me what the select statement was.

My customer needs to know what records in the table were accessed and by whom.

Triggers won't work because those are only for update, delete and update.

I was thinking that the solution would be to link dba_audit_object to v$sqlarea (if possible) and filtering by returned view by object name.

Is there a way to do this?

Adrian
Certified DBA/Developer

 

[taupirho]

If you have Oracle9i, log miner may do some or all of things you require.