I have a read-only table which contains confidential information and I want to be able to know who is querying that table and exactly what select statement they are issuing.
I have turned on auditing for select only on that table and can see who querying the table and when. But I can't see the SQL issued. I know the SQL is in V_$SQLAREA and I thought of capturing it in a separate table when the AUD$ table has an entry written to it but I get an error message indicating that you can't write a trigger for a table in the SYS schema.
I want to have some way of automatically writing timestamp, osuser, username, terminal and SQL_text to a table and then reviewing the table once a week or so.
11-07-2000, 10:52 AM
Sorry for this reply, but this feature will be in Oracle9i
Maybe you want to encapsulate the table in a Stored Procedure like Object-Oriented approach.
11-07-2000, 11:20 AM
What will be in 9i that will alleviate this problem?
Can you say more about encapsulating the table in a Stored Procedure like Object-Oriented approach? Which table? I'm not clear what you are suggesting and how it would resolve the issue?