Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle Audit
09-25-2015, 03:46 PM
Post: #1
Oracle Audit
1. Enable Audit
$sqlplus / as sysdba
SQL> alter system set audit_sys_operations=TRUE scope=SPFILE;
SQL> alter system set audit_trail=db_extended scope=SPFILE;
/* restart */
SQL> shutdown immediate
SQL> startup

2. Set auditing
/* e.g, audit insert on table scott.test */
SQL>audit insert on scott.test by access

3. Get log
$ sqlplus scott
/* insert records into test table */
/* get audit log */
SQL> SELECT obj_name, action_name, sql_text, timestamp
FROM dba_audit_trail
WHERE username = 'SCOTT' and action_name='insert';

Reference:
https://community.oracle.com/thread/2379152
http://oracleflash.com/16/audit-trail-ex...http://oracleflash.com/16/audit-trail-example-in-oracle-
https://oracle-base.com/articles/10g/auditing-10gr2
Quote this message in a reply
09-28-2015, 11:54 AM
Post: #2
RE: Oracle Audit
There should be a general replication function in many relational databases -- it replicates the log of the DB to one or more remote DBs and the remote DBs apply the changes in the replicated log entries so as to keep with with the updates in the original DB. I wonder how Oracle does it.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump: