在《初識企業內容管理平台-Documentum》中提到
Oracle
Create Table T_AUDIT_DEMO
(
CID INT NOT NULL
CONSTRAINT PK_T_AUDIT_DEMO PRIMARY KEY (CID)
);
begin
dbms_fga
(
object_schema=>
policy_name=>
);
end;
INSERT INTO T_AUDIT_DEMO VALUES(
INSERT INTO T_AUDIT_DEMO VALUES(
INSERT INTO T_AUDIT_DEMO VALUES(
SQL> SELECT * FROM T_AUDIT_DEMO;
CID CNAME ENAME
SQL> select statement_type
STATEMENT_TYPE SQL_TEXT
SELECT SELECT * FROM T_AUDIT_DEMO
注意
begin
dbms_fga
(
object_schema=>
);
end;
注意
INSERT INTO T_AUDIT_DEMO VALUES(
DELETE FROM T_AUDIT_DEMO WHERE CID <
SQL> select statement_type
STATEMENT_TYPE SQL_TEXT
SELECT SELECT * FROM T_AUDIT_DEMO
INSERT INSERT INTO T_AUDIT_DEMO VALUES(
DELETE DELETE FROM T_AUDIT_DEMO WHERE CID <
SELECT SELECT * FROM T_AUDIT_DEMO
至此
select * from fga$
select * from fga_log$
select * from fgacol$
select * from dba_fga_audit_trail
select * from dba_common_audit_trail
select * from dba_audit_policies
select * from dba_fga_audit_trail
與FGA相關的包或者過程
dbms_fga
至於這些表
From:http://tw.wingwit.com/Article/program/Oracle/201311/16575.html