Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpsg\tdpsg_auditing024.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Guidelines for Auditing Typical Database Activity</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-06-02T18:13:4Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Guidelines for Auditing Typical Database Activity" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10575-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdpsg_auditing023.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpsg_auditing025.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdpsg_auditing023.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpsg_auditing025.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="i1007821" name="i1007821"></a><a id="TDPSG60683" name="TDPSG60683"></a></p> <div class="sect2"> <h1>Guidelines for Auditing Typical Database Activity</h1> <a name="BEGIN" id="BEGIN"></a> <p>When <a id="sthref515" name="sthref515"></a><a id="sthref516" name="sthref516"></a>your purpose for auditing is to gather historical information about particular database activities, follow these guidelines:</p> <ol> <li> <p><span class="bold">Audit only pertinent actions.</span></p> <p>To avoid cluttering meaningful information with useless audit records and to reduce the amount of audit trail administration, audit only the targeted database activities. You can audit specific actions by using fine-grained auditing. <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=DBSEG525','newWindow').focus()"><span class="italic">Oracle Database Security Guide</span></a> describes fine-grained auditing in detail.</p> </li> <li> <p><span class="bold">Archive audit records and purge the audit trail.</span></p> <p>After you collect the required information, archive the audit records of interest, and purge the audit trail of this information.</p> <p>To archive audit records, you copy the relevant records to a database table, for example, using <code>INSERT INTO</code> <code><span class="codeinlineitalic">table</span></code> <code>SELECT ... FROM SYS.AUD$ ...</code> for the standard audit trail. (Fine-grained audit records are in the <code>SYS.FGA_LOG$</code> table.) Alternatively, you can export the audit trail table to an operating system<a id="sthref517" name="sthref517"></a><a id="sthref518" name="sthref518"></a> file. <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=SUTIL200','newWindow').focus()"><span class="italic">Oracle Database Utilities</span></a> explains how to export tables by using Oracle Data Pump.</p> <p>To purge audit records, you delete standard audit records from the <code>SYS.AUD$</code> table and fine-grained audit records from the <code>SYS.FGA_LOG$</code> table. For example, to delete <span class="italic">all</span> audit records from the standard audit trail, enter the following statement:</p> <pre xml:space="preserve" class="oac_no_warn"> DELETE FROM SYS.AUD$; </pre> <p>Alternatively, to delete all audit records from the standard audit trail generated as a result of auditing the table <code>emp</code>, enter the following statement:</p> <pre xml:space="preserve" class="oac_no_warn"> DELETE FROM SYS.AUD$ WHERE obj$name='EMP'; </pre></li> <li> <p><span class="bold">Remember the privacy considerations of your company.</span></p> <p>Privacy regulations often lead to additional business privacy policies. Most privacy laws require businesses to monitor access to personally identifiable information (PII), and this type of monitoring is implemented by auditing. A business-level privacy policy should address all relevant aspects of data access and user accountability, including technical, legal, and company policy concerns.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpsg_auditing022.htm#CHDBEBEE">Guideline for Using Default Auditing of SQL Statements and Privileges</a></p> <p><a href="tdpsg_auditing023.htm#i1010870">Guidelines for Managing Audited Information</a></p> </div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2006, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdpsg_auditing023.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpsg_auditing025.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de