Oracle PL/SQL Tutorial/System Packages/dbms fga

dbms_fga.add_policy

   <source lang="sql">

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></source>