Grant the 'reportuser' User the Permission to Access Views

This section is for customers using an Oracle database. If you experience issues creating or running the JasperReports Server application due to denied permissions or a missing table or view in the Oracle database, you must grant the reportuser user  permission to access the required view to run the reports.

To grant the 'reportuser' user with the permission to access the views:

1. Open command prompt and navigate to the %AGILIANCE_HOME%\RiskVision\Utils directory.

2. To obtain the password in an encrypted format, enter the following command:

   encrypt.cmd <password>

   A new password is generated and appears in an encrypted format.

3. Go to the %AGILIANCE_HOME%\config directory path, open the agiliance.properties file by using a text editor, and add the following properties:

   • jasper.reportuser.name

   • jasper.reportuser.password.encrypted

   • database.oracle.admin.password.encrypted (in encrypted format) (required, only if the Daily Server and Database Hot Backup job is accountable for backing up the Oracle database)

4. Open the command prompt, navigate to the directory%AGILIANCE_HOME%\Install\Toolbox\bin, and enter theassign_jasper_permissions.cmd command.