0 Replies Latest reply: Aug 29, 2012 10:21 AM by user707073 RSS

    Changes made with dbms_macadm.UPDATE_RULE_SET are lost after bounce db

    user707073
      Hi,
      We have Oracle Database 11.2.0.1 with Database Vault functioning ok but we need to change two rule sets.
      We modify the rule sets with dvsys.dbms_macadm.UPDATE_RULE_SET and the change was applied immediately.
      After bounce the database the changes were lost and we have to applied again.
      Specifically we want to change a rule set from no static to static so we run the following commands:
      begin
      dvsys.dbms_macadm.UPDATE_RULE_SET (
      rule_set_name => 'Limit DBA'
      ,description => 'Limit DBA access'
      ,enabled => 'Y'
      ,eval_options => 2
      ,audit_options => 1
      ,fail_options => 1
      ,fail_message =>''
      ,fail_code => NULL
      ,handler_options => 0
      ,handler => ''
      ,is_static => TRUE
      );
      commit;
      end;
      /
      begin
      DVSYS.DBMS_MACADM.SYNC_RULES();
      end;
      /

      Are we missing something else ?
      Thanks.
      Regards.