PROSAGA码农传奇-大数据安全-Oracle - 针对特定用户的Audit Trail

<div class =“post-text”itemprop =“text”>
  
    首先，您需要通过设置在数据库中启用审核
     <code>
 audit_trail
 </code>
     参数如下图所示 - 
  
   <pre>
 <code>
 SQL> alter system set audit_trail='OS|DB|DB,EXTENDED|XML|XML, EXTENDED';

</code>
 </pre>
  
    <a href="https://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50514" rel="nofollow noreferrer">
      用于审计的初始化参数
    </A>
  
  
    然后，您可以审核用户 - 
  
   <pre>
 <code>
 SQL>CONNECT sys/password AS SYSDBA

SQL> AUDIT ALL BY username BY ACCESS;
SQL> AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY username BY ACCESS;
SQL> AUDIT EXECUTE PROCEDURE BY username BY ACCESS;

</code>
 </pre>
  
    <a href="https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_4007.htm#SQLRF01107" rel="nofollow noreferrer">
      审计
    </A>
  
  
    审计记录可以在中找到
     <code>
 DBA_AUDIT_TRAIL
 </code>
     view.Following查询列出所有审计相关的视图。
  
   <pre>
 <code>
 SQL>SELECT view_name FROM dba_views WHERE view_name LIKE 'DBA%AUDIT%';

</code>
 </pre>
  
    细粒度审核仅在Enterprise Edition中提供。
  
  
    <a href="https://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC116" rel="nofollow noreferrer">
      版本的功能可用性
    </A>
  
</DIV>