Oracle PL/SQL Tutorial/System Packages/dbms fga

dbms_fga.add_policy

SQL>
SQL> begin
  2    dbms_fga.add_policy (
  3      object_schema => "HR",
  4      object_name   => "EMP",
  5      policy_name   => "EMP_SEL",
  6      audit_column  => "SAL, COMM",
  7      audit_condition => "SAL >= 150000 OR EMPID = 100"
  8    );
  9  end;
 10  /
begin
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained Auditing
ORA-06512: at "SYS.DBMS_FGA", line 17
ORA-06512: at line 2

SQL>
SQL>
SQL> begin
  2     dbms_fga.add_policy (
  3        object_schema   => "HR",
  4        object_name     => "EMP",
  5        policy_name     => "EMP_DML",
  6        audit_column    => "SALARY, COMM",
  7        audit_condition => "SALARY >= 150000 OR EMPID = 100",
  8        statement_types => "SELECT, INSERT, DELETE, UPDATE"
  9     );
 10  end;
 11  /
begin
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained Auditing
ORA-06512: at "SYS.DBMS_FGA", line 17
ORA-06512: at line 2

SQL>
SQL>
SQL> begin
  2     dbms_rls.add_policy (
  3        object_name      => "EMP",
  4        policy_name      => "EMP_POLICY",
  5        function_schema  => "HR",
  6        policy_function  => "AUTHORIZED_EMPS",
  7        statement_types  => "INSERT, UPDATE, DELETE, SELECT",
  8        update_check     => true
  9     );
 10  end;
 11  /
begin
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained access control
ORA-06512: at "SYS.DBMS_RLS", line 20
ORA-06512: at line 2

SQL>