Configure the Security

The security scripts must be executed after the initial load and the materialized views are created for the given source product instance.

1. In the Oracle Utilities Analytics Warehouse database component installation package, navigate to the directory <TEMPDIR>/database/BI251000/DWADM/Install-Upgrade.

2. Set the Java Home and Classpath, and run OraGenSec.

   export JAVA_HOME=<JAVA 17 HOME>
   export PATH=$JAVA_HOME/bin:$PATH
   export CLASSPATH=<TEMPDIR>/BI251000/DWADM/Jarfiles/*
   java com.oracle.ouaf.oem.install.OraGenSec -d DWADM,DWADM,jdbc:oracle:thin:@<DATABASE SERVER>:<DATABASE PORT>/<ORACLE SERVICE NAME> -u DWUSER,DWREAD -r DW_USER,DW_READ  -p <DWUSER>,<DWREAD> -a A  CAPTION:Configuring Security LANGUAGE:ALL