dbms_fga.add_policy : dbms_fga « System Packages « Oracle PL/SQL Tutorial






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>








31.9.dbms_fga
31.9.1.dbms_fga.add_policy