Oracle Database: Program with PL/SQL — Question 49

Which two statements are true with respect to fine-grained access control?

Answer options

• A. It is implemented by end users.
• B. It can be used to implement column masking.
• C. It implements security rules through functions and associates these security rules with tables, views or synonyms.
• D. Separate policies are required for queries versus INSERT/UPDATE/DELETE statements.
• E. The DBMS_FGA package is used to set up fine-grained access control.

Correct answer: C, D

Explanation

Option C is correct because fine-grained access control indeed uses functions to enforce security rules linked to database objects. Option D is also accurate, as it states that different policies are necessary for various types of statements. Options A, B, and E do not correctly represent the implementation or use of fine-grained access control.