小编给大家分享一下甲骨文国外一般代理人(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