开发者

Turn on DDL auditing

How to audit DDL statements in oracle 10g and clear audited data before 30days... Thank you.

IN EDITION:

How can I turn on auditing on "ALTER TABLE" statement? when I run AUDIT TABLE; or AUDIT ALTER TABLE; or AUDIT ALTER ANY TABLE; Audited information can'开发者_如何学JAVAt be seen in AUD$ or DBA_AUDIT_TRAIL views.(Just event when system user alters table is written,but there is no record for HR user) why????


http://www.oracle-base.com/articles/10g/Auditing_10gR2.php


Check if the audit option is enabled:

 select value
 from v$parameter
 where name = 'audit_trail';

if the result is 'NONE' (which is default) then the audit is not turned on.

To enable audit you must set the AUDIT_TRAIL initialization parameter in the database initialization parameter file. The parameter must be set to one of the following values: 'DB', 'XML', 'DB,EXTENDED', 'XML,EXTENDED', 'OS'.

For managing audit trail records you can use the DBMS_AUDIT_MGMT package.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜