Multiple choice technology databases

Which two statements are true about the working of fine-grained access? (Choose two.)

  1. Security policies can be associated only with tables, but not with views.

  2. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.

  3. User statements are dynamically modified by the Oracle server through a security policy function.

  4. Fine-grained access control policies always remain in effect until they are dropped from a table or view.
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Oracle's Fine-Grained Access Control (FGAC) dynamically modifies SQL statements using policies that append WHERE clauses. Policies can differ by statement type (SELECT, INSERT, etc.) and apply to both tables and views.

Keep practicing — related questions