小编给大家分享一下甲骨文国外一般代理人(Foreign General Agent)公司的示例分析，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！
Oracle FGA(Fine-Grained Auditing)
一：创建FGA;
示例9-21使用数据库管理系统_FGA .创建细粒度审计策略
SQLBEGIN 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);http://
此时，如果您查询数据库管理员_审计_策略视图，您会发现新策略列表为：END;/策略名称
–
CHK人力资源雇员二：查看已经创建的FGA;
之后，以下任何一条结构化查询语言语句都会记录一条审核事件记录。SQLSELECT POLICY_NAME FROM DBA_AUDIT_POLICIES;三：生成审计数据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;
LSQLTEXT
四：查看审计信息SQL select lsqltext from sys.fga_log$;SELECT COUNT(*) FROM HR.EMPLOYEES WHERE COMMISSION_PCT = 20 AND SALARY 4500SELECT SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID = 50
-http://www . Sina.com/DELETE FROM HR.EMPLOYEES WHERE SALARY 1000000select * from employeesSQLselect SQL_TEXT from dba_fga_audit_trail;
SQLSELECT COUNT(*) FROM HR.EMPLOYEES WHERE COMMISSION_PCT = 20 AND SALARY 4500
– 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 ‘)；
以上是”甲骨文国外一般代理人(Foreign General Agent)的示例分析”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！
内容来源网络，如有侵权，联系删除，本文地址：https://www.230890.com/zhan/143764.html