Practice exercise

• Identify the correct statements about the working of Fine Grained Access Control.

  1. A table can have only one security policy.

  2. Different policies can be used to protect the SELECT, INSERT, UPDATE, and DELETE statements on a table, but not one.

  3. The policy function returns the predicate information as WHERE <Column> = <Value>.

  4. Once associated, the FGAC policy cannot be revoked from the table.

• A security policy can be associated to a group of objects by the DBA. State whether this is true or false.

  1. True

  2. False

• Choose the correct statement about DBMS_RLS.

  1. DBMS_RLS is used only for row-level security policies.

  2. The package is owned by SYS.

  3. It can create / drop / refresh policies and create/drop policy groups.

  4. Using DBMS_RLS to set the policy degrades the application performance.

• Identify the correct statements about the context of an application.

  1. A user who holds the CREATE CONTEXT privilege can create a context.

  2. It is owned by the SYS user.

  3. A user can check the context metadata in...