QUESTION 80/Fine-Grained Auditing

You execute the following PL/SQL:
BEGIN
DBMS_FGA.add_policy(
object_schema => 'JIM',
object_name => 'PRODUCTS',
policy_name => 'PROD_AUDIT',
audit_condition => 'PRICE > 10000',
audit_column => 'PRICE');
END;
/
Which two statements are true?
A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000is accessed.
B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000is accessed.
C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
Correct Answer: AD

 

只有当访问价格为> 10000的行时，才会为SELECT语句的PRODUCTS表中的PRICE列启用细粒度审计(FGA)。

在PRODUCTS表的PRICE列启用FGA，并且在FGA审计试验中捕获SQL语句。
 
DBMS_FGA.ADD_POLICY (object_schema => ‘hr’,object_name => ‘emp’,policy_name =>‘chk_hr_emp’,audit_condition => ‘dept = ”SALES” ‘,audit_column => ‘salary’statement_types =>‘insert,update,delete,select’); Default value for statement_types is SELECT
- Setting audit_trail to DBMS_FGA.DB sends the audit trail to the SYS.FGA_LOG$ table in the database and omits SQL Text and SQL Bind.
- Setting audit_trail to DBMS_FGA.DB+EXTENDED sends the audit trail to the SYS.FGA_LOG$ table in the database and includes SQL Text and SQL Bind.
- Setting audit_trail to DBMS_FGA.XML writes the audit trail in XML files sent to the operating system and omits SQL Text and SQL Bind.
- Setting audit_trail to DBMS_FGA.XML+EXTENDED writes the audit trail in XML files sent to the operating system and includes SQL Text and SQL Bind. Default value fo audit_trail parameter in DBMS_FGA.ADD_POLICY is DB+EXTENDED