This discussion is archived
0 Replies Latest reply: Aug 29, 2012 8:21 AM by user707073 RSS

Changes made with dbms_macadm.UPDATE_RULE_SET are lost after bounce db

user707073 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points