Configure the Security

On-premise

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

PaaS

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 Oracle Cloud Infrastructure virtual machine where database components are downloaded and have access to the Autonomous Database.

1. Add Java to path variable..

   export JAVA_HOME=<JAVA 17 HOME>
   export PATH=$JAVA_HOME/bin:$PATH

2. Set the classpath to point to OraDBI.jar and all dependency jars.

   export CLASSPATH=<TMPDIR>/BI251000/DWADM/Jarfiles/*

3. Navigate to the directory <TEMPDIR>/BI251000/DWADM/Install-Upgrade and run OraGenSec.

   java com.oracle.ouaf.oem.install.OraGenSec -d DWADM,<DWADM Password>,jdbc:oracle:thin:@<ADB TNS Service Name>?TNS_ADMIN=<ADB Wallet Directory Path> -u DWUSER,DWREAD -r DW_USER,DW_READ  -p <DWUSER Password>,<DWREAD Password> -a A  CAPTION:Configuring Security LANGUAGE:ALL