Database Vault - Rule Working

Doing a POC

I have added a Rule Set with eval_options => DBMS_MACUTL.G_RULESET_EVAL_ALL

According to my understanding it should work if all of condition satisfies..

I have added RUle with below command.

BEGIN

DBMS_MACADM.CREATE_RULE(

 rule_name => 'Time1', 

 rule_expr => 'TO_CHAR(SYSDATE,''HH24'') BETWEEN ''18'' AND ''20''');

END;

/

Added the rule to ruleset

BEGIN

DVSYS.DBMS_MACADM.CREATE_COMMAND_RULE

(command => 'TRUNCATE',rule_set_name => 'RS7',object_owner => 'WEST',object_name => '%',enabled => DVSYS.DBMS_MACUTL.G_YES);

end;

/

Then added the command rule for truncate table in a schema