Database Vault: Command Rules does not work correctly
Hello,
I'm working with Oracle 12.2.0.1.0 on Linux, and trying to créate a command rule that check if the user has granted a role to allow do a SELECT operation, is not working.
Here is my steps.
1. Create a RULE set, with DV owner.
set echo on
exec DBMS_MACADM.DELETE_RULE_SET(rule_set_name => 'HAS_APP_ROLE');
BEGIN
DBMS_MACADM.CREATE_RULE_SET(
rule_set_name => 'HAS_APP_ROLE',
description => 'Filtro para ver si tienes una ROLE de control',
enabled => DBMS_MACUTL.G_YES,
eval_options => DBMS_MACUTL.G_RULESET_EVAL_ALL,
audit_options => DBMS_MACUTL.G_RULESET_AUDIT_FAIL + DBMS_MACUTL.G_RULESET_AUDIT_SUCCESS,