共計 1909 個字符，預計需要花費 5 分鐘才能閱讀完成。
丸趣 TV 小編給大家分享一下 Oracle FGA 的示例分析，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！
Oracle FGA(Fine-Grained Auditing)
一：創建 FGA;
Example 9-21 Using DBMS_FGA.ADD_POLICY to Create a Fine-Grained Audit Policy
SQL
BEGIN
DBMS_FGA.ADD_POLICY(
object_schema = HR ,
object_name = EMPLOYEES ,
policy_name = chk_hr_employees ,
enable = TRUE,
statement_types = INSERT, UPDATE, SELECT, DELETE ,
audit_trail = DBMS_FGA.DB+DBMS_FGA.EXTENDED);
END;
/
二：查看已經創建的 FGA;
At this point, if you query the DBA_AUDIT_POLICIES view, you will find the new policy listed:
SQL SELECT POLICY_NAME FROM DBA_AUDIT_POLICIES;
POLICY_NAME
——————————
CHK_HR_EMPLOYEES
三：生成審計數據
Afterwards, any of the following SQL statements log an audit event record.
SQL SELECT COUNT(*) FROM HR.EMPLOYEES WHERE COMMISSION_PCT = 20 AND SALARY 4500;
SQL SELECT SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID = 50;
SQL DELETE FROM HR.EMPLOYEES WHERE SALARY 1000000;
SQL select * from employees;
四：查看審計信息
SQL select lsqltext from sys.fga_log$;
LSQLTEXT
——————————————————————————–
SELECT COUNT(*) FROM HR.EMPLOYEES WHERE COMMISSION_PCT = 20 AND SALARY 4500
SELECT SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID = 50
DELETE FROM HR.EMPLOYEES WHERE SALARY 1000000
select * from employees
SQL select SQL_TEXT from dba_fga_audit_trail;
SQL_TEXT
——————————————————————————–
SELECT COUNT(*) FROM HR.EMPLOYEES WHERE COMMISSION_PCT = 20 AND SALARY 4500
SELECT SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID = 50
DELETE FROM HR.EMPLOYEES WHERE SALARY 1000000
select * from employees
五：刪除 chk_hr_employees 審計
SQL exec DBMS_FGA.DROP_POLICY(object_schema= HR ,object_name= EMPLOYEES ,policy_name= chk_hr_employees
—SQL exec DBMS_FGA.DISABLE_POLICY_POLICY(object_schema= HR ,object_name= EMPLOYEES ,policy_name= chk_hr_employees
—SQL exec DBMS_FGA.ENABLE_POLICY(object_schema= HR ,object_name= EMPLOYEES ,policy_name= chk_hr_employees
以上是“Oracle FGA 的示例分析”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注丸趣 TV 行業資訊頻道！
