Oracle-特定用户的审计跟踪 [英] Oracle - Audit Trail for a specific user

问题描述

正如该主题所述，我正在寻找一种方法让我们跟踪特定用户的活动.可能具有或不具有SYSDBA或SYSOPER特权.

As stated on the topic , I am looking for a way for us to track on the activities of the specific user. May or may not have the SYSDBA or SYSOPER privilege.

例如HR.

我想知道他的登录信息是什么，他更改了哪些对象，它们的原始值是什么，执行的SQL语句是什么，执行的过程/功能是什么.

I would like to know what are the details of his login , what are the objects that are changed by him , what were their original values , SQL statements executed , what procedure/functions that were executed etc.

我们可以在Oracle 11gR2 Standard/Enterprise中设置此类审计跟踪日志吗?

Could we set up such audit trail log in Oracle 11gR2 Standard/Enterprise?

谢谢

推荐答案

首先，您需要通过设置如下所示的audit_trail参数在数据库中启用审核-

First of all you need to enable auditing in your database by setting audit_trail parameter as shown below-

SQL> alter system set audit_trail='OS|DB|DB,EXTENDED|XML|XML, EXTENDED';

用于审核的初始化参数

然后，您可以将用户审核为-

Then, you can audit user as-

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;

审核

审计记录可以在DBA_AUDIT_TRAIL视图中找到.下面的查询列出了所有与审计相关的视图.

Audit records can be found in DBA_AUDIT_TRAIL view.Following query list all audit related views.

SQL>SELECT view_name FROM dba_views WHERE view_name LIKE 'DBA%AUDIT%';

细粒度审核仅在企业版中可用.

Fine-grained auditing is available in Enterprise Edition only.

按版本提供的功能

这篇关于Oracle-特定用户的审计跟踪的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！