Configure the Security

After all star schemas are loaded successfully and their respective materialized views are created (that is, materialized views exist for the source product), the next step is for security scripts to be executed for the given source product instance. For configuring the security, perform the following steps in Linux environment:

• Add Java 8 to path variable, as shown in example below:

  export PATH=/scratch/softwares/jdk1.8.0_121/bin:$PATH

• Set classpath pointing to OraDBI.jar and all dependency jars.

  export CLASSPATH=<Path to BI270>/BI270/DWADM/Jarfiles/*

• Run OraGenSec as shown below:

  java com.oracle.ouaf.oem.install.OraGenSec -l oragensec.log -d DWADM,DWADM,jdbc:oracle:thin:@<DATABASE SERVER>:<DATABASE PORT>/<ORACLE SERVICE NAME> -a A -r DW_READ,DW_USER -u DWREAD,DWUSER