How to track and record all SQL insert commands

Question

I am using Oracle SQL Dev 2.1.1.64

I am working with an application that uses an oracle database for storage. Is there a way in SQL Dev. monitor and log all the insert commands that come from the web application to the database? Can you tell me how to do this?

Answer 1

audit insert table by <web-application-user> by access

should get started.

Be sure to set the parameters audit_trailand audit_file_destas needed.

After that, you will find the operations either in sys.aud$or in the directory indicated audit_file_dest.

fine grained auditing, , (FGA) .

Answer 2

, . , -, /, , -.

Oracle AUDIT. Oracle Database Administration...

Answer 3

v $SQL, GRANTS, .

, v $session_longops

, .

Answer 4

Create a trigger that writes to the logging table whenever there is a change in the data in the table (insert, update, delete). Before uninstalling after pasting after update triggers you want.

It will not specifically register only the web application, but if you register the user who made the changes, you can filter it when viewing the data.