Q

Auditing or tracking changes in Oracle 10g

Is there a way to audit or track changes to an Oracle 10g database? I need to find out who makes changes to users, tables or anything at all.

Is there a way to audit or track changes to an Oracle 10g database? I need to find out who makes changes to users, tables or anything at all.
Oracle has a built-in Audit Trail, but you must turn on auditing for those things you want to track. The Oracle documentation is a good place to start to learn what can and can't be audited. Please read the Oracle Security Guide. Pay close attention to Chapter 8, "Database Auditing: Security Considerations," and Chapter 12, "Configuring and Administering Auditing."
This was first published in December 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close