3 Replies Latest reply: Oct 18, 2006 3:34 PM by Nicolas.Gasparotto RSS

    dbms_rls.add_policy with Oracle 10g Express Edition

    532015
      SQL> begin
      2 dbms_rls.add_policy(
      3 object_schema => 'VPD',
      4 object_name => 'TRANSACTIONS',
      5 policy_name => 'VPD_TEST_POLICY',
      6 function_schema => 'VPD',
      7 policy_function => 'VPD_POLICY.VPD_PREDICATE',
      8 statement_types => 'select, insert, update, delete',
      9 update_check => TRUE,
      10 enable => TRUE,
      11 static_policy => FALSE);
      12 end;
      13 /
      Gives an ORA error as follows
      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
      i'am using Oracle 10g Express Edition
      Please get back as soon as possible