这听起来像是在’审计’之后. Oracle有一个名为Fine Grain Auditing(FGA)的内置功能.简而言之,您可以审核所有内容或特定条件.真正酷的是你可以’审核’选择以及交易.简单的命令来开始审计:
audit UPDATE on SCOTT.EMP by access;
将其视为select语句的“触发器”.例如,您创建策略:
begin
dbms_fga.add_policy (
object_schema=>'BANK',
object_name=>'ACCOUNTS',
policy_name=>'ACCOUNTS_ACCESS'
);
end;
定义策略后,当用户以常规方式查询表时,如下所示:
select * from bank.accounts;
审计跟踪记录此操作.您可以通过发出以下内容来查看路径
select timestamp,
db_user,
os_user,
object_schema,
object_name,
sql_text
from dba_fga_audit_trail;
TIMESTAMP DB_USER OS_USER OBJECT_ OBJECT_N SQL_TEXT
--------- ------- ------- ------- -------- ----------------------
22-OCT-08 BANK ananda BANK ACCOUNTS select * from accounts