OCP-042 fine-grained Auditing
来源:互联网 发布:协同过滤算法仿真 编辑:程序博客网 时间:2024/05/26 19:20
13. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank.
As part of the yearend
tax and interest calculation process, all the rows in the table need to be accessed.
The bank authorities want to track access to the rows containing balance amounts exceeding $200,000,
and then send an alert message to the administrator.
Which method would you suggest to the bank for achieving this task?
A. implementing valuebased
auditing by using triggers
B. implementing finegrained
auditing with audit condition and event handler
C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL
parameter to EXTENDED
D. performing standard database auditing to audit SQL statements with granularity level set to ACCESS
Answer: B
Fine-Grained Auditing
Fine-grained auditing allows the monitoring of data access based on content. It provides granular auditing of queries, as well as INSERT
, UPDATE
, and DELETE
operations. For example, a central tax authority needs to track access to tax returns to guard against employee snooping, with enough detail to determine what data was accessed. It is not enough to know that SELECT
privilege was used by a specific user on a particular table. Fine-grained auditing provides this deeper functionality.
In general, fine-grained auditing policy is based on simple user-defined SQL predicates on table objects as conditions for selective auditing. During fetching, whenever policy conditions are met for a returning row, the query is audited. Later, Oracle runs user-defined audit event handlers using autonomous transactions to process the event.
Fine-grained auditing can be implemented in user applications using the DBMS_FGA
package or by using database triggers.
- OCP-042 fine-grained Auditing
- Fine-Grained Auditing test (精细审计:FGA测试)
- fine-grained & coarse grained
- Fine-Grained Crowdsourcing for Fine-Grained Recognition(精读)
- 粗粒度(Coarse-grained)vs细粒度(fine-grained)
- Oracle Fine-Grained Access Control Lab
- Fine-Grained Classification之车型识别
- (转)oracle审计—精细审计(Fine-Grained Audit)
- Oracle FGA(Fine-Grained Audit)细粒度审计的用法
- Learning Fine-grained Image Similarity with Deep Ranking(泛读)
- Part-based R-CNNs for Fine-grained Category Detection(精读)
- Unsupervised Template Learning for Fine-Grained Object Recognition(精读)
- 论文提要“Hypercolumns for Object Segmentation and Fine-grained Localization”
- PS:Hypercolumns for Object Segmentation and Fine-Grained Localization__CVPR2015
- Learning Deep Representations of Fine-Grained Visual Descriptions
- Unsupervised template learning for fine-grained object recognition
- Embedding label structures for fine-grained features representation
- Fine-Grained Recognition with Automatic and Efficient Part Attention
- static声明
- 流年,经不起怀念
- poj 2186 Popular Cows
- 从最权威的文献中了解访问控制的发展
- 如何编译MTK的模拟器
- OCP-042 fine-grained Auditing
- linux进程调度方法(SCHED_OTHER,SCHED_FIFO,SCHED_RR)
- 行业云应用创新加快,云数据中心建设规范呼之欲出
- java 获取properties配置文件例子
- 2.每颗继承树两张表:工具类
- 在U盘运行Win8(win to go)
- 如何编译单双卡版本
- iOS_MonkeyTalk(3)_How to Install the MonkeyTalk Agent
- Vitamio