CREATE TABLE BUILD_TEST01
(
X NUMBER,
Y NUMBER
)
INSERT INTO BUILD_TEST01 VALUES(2,2)

Creating an FGA Policy(disabled)

exec DBMS_FGA.ADD_POLICY(object_schema=>'HT',object_name=>'BUILD_TEST01',policy_name=>'TEST_AUD',audit_column=>'X,Y',enable=>FALSE,statement_types=>'UPDATE');

Enabling THE FGA Policy

exec DBMS_FGA.ENABLE_POLICY(object_schema=>'HT',object_name=>'BUILD_TEST01',policy_name=>'TEST_AUD');

execute update

UPDATE build_test01 SET X=22,Y=33;

Reporting on the FGA Audit Trail Entries

SELECT session_id,TIMESTAMP,db_user,os_user,userhost,sql_text FROM Dba_Fga_Audit_Trail;

查询出数据

Disabling the FGA Policy
exec DBMS_FGA.DISABLE_POLICY(object_schema=>'HT',object_name=>'BUILD_TEST01',policy_name=>'TEST_AUD');

Dropping the FGA Policy

EXEC DBMS_FGA.DROP_POLICY(object_schema=>'HT' ,object_name=>'BUILD_TEST01' ,policy_name=>'TEST_AUD');

ITPub博客

转载 FGA(fine-grained auditing )

最新文章