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>
