Creating factors in Oracle Database Vault
In this recipe, you'll create three factors (Day
, Holiday
, and NonWorkingDay
). The factor Day
will return name of the day based on sysdate
. The factor Holiday
will return TRUE
if it is a company nonworking holiday (for example, 1-JAN
, 4-JUL
, and 15-NOV
) and FALSE
otherwise. The factor NonWorkingDay
will return whether it's a nonworking day (NO
, WEEKEND
, and COMPANY_HOLIDAY
). We'll assume that a day is a nonworking day if it is a weekend or a company nonworking holiday (in case it is both weekend and holiday, it should resolve it to COMPANY_HOLIDAY
).
Getting ready
It is assumed that:
- You are using Oracle Database 12.1.0.2 (the traditional architecture) on Linux and Oracle Enterprise Manager Cloud Control 12c
- Database Vault is enabled and configured (the Database Vault owner is the user
dbv_owner
and account manager is the userdbv_acctmgr
).
- The user
dbv_owner
has been granted theSELECT ANY DICTIONARY
privilege - The user
piter
exists...