Database Security Products (MOSC)

MOSC Banner

Database Vault: Command Rules does not work correctly

edited Aug 8, 2018 5:06AM in Database Security Products (MOSC) 2 commentsAnswered

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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center