Oracle 10g Audit（审计） --- 记录登录用户在Oracle中的所有操作

由于项目平台管理的需要，最近在研究Oracle 10G的审计功能，以便记录和跟踪用户在Oracle数据库系统中的所有操作行为，进而提高Oracle的安全性。现在把审计功能的配置步骤分享出来，供大家参考：

 

1、以DBA登录Oracle

 

# su - oracle
$ sqlplus /nolog
SQL> conn / as sysdba

 

2、查看当前审计设置

 

SQL> show parameter audit;

 

参数说明

AUDIT_TRAIL = { none | os | db | db,extended | xml | xml,extended }
none or false - Auditing is disabled.
db or true - Auditing is enabled, with all audit records stored in the database audit trial (SYS.AUD$).
db,extended - As db, but the SQL_BIND and SQL_TEXT columns are also populated.
xml- Auditing is enabled, with all audit records stored as XML format OS files.
xml,extended - As xml, but the SQL_BIND and SQL_TEXT columns are also populated.
os- Auditing is enabled, with all audit records directed to