Q
Problem solve Get help with specific problems with your technologies, process and projects.

Checking table changes

How can I check which table is updated/inserted by which machine/user at what time?

You have two options here. The first option is to use auditing on the tables in question. For instance, to audit UPDATES on the SCOTT.EMP table, issue the following command:

AUDIT update ON scott.emp WHENEVER SUCCESSFUL;
Whenever anyone performs a successful UPDATE command on SCOTT.EMP, an entry will be logged in the DBA_AUDIT_TRAIL view. There are many options with the AUDIT command, so please consult the Oracle documentation. This option is more preventative than reactionary. You have to turn on auditing before you can see the results.

The second option is to use LogMiner to see the operations. This option is more reactionary as it can be performed after the fact. LogMiner is quite a lengthy topic, so I will refer you to the relevant section in the Oracle Utilities Guide.

Dig Deeper on Oracle database security

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close