NetIQ Identity Governance Report Database Update

Report affected by this update

Separation of Duties Open Violations Details

Product Version

IG 2.5.1

Details

Overview:

This update includes the modified and affected views required by the report.

System Requirements:

NetIQ Identity Governance 2.5 or higher.

Non-default Database User:

If Identity Governance was installed to use a non-default database user account instead of igops, it will be necessary to modify the SQL files in this download package to replace all instances of igops with the name of the corresponding database account defined for the environment.

Modify only the SQL files necessary for the database type in the environment. The file names for Oracle begin with "or-" and the file names for PostgreSQL begin with "pg-".

View Dependencies:

Some Identity Governance report views have dependencies on one another. In cases where a report view definition has been modified for a report, if it is part of a view dependency tree, the view definitions for the entire dependency tree are provided in the SQL file.

The file names for these view dependency tree bundles are prefixed with "or-" or "pg-" to indicate whether they are intended for Oracle or PostgreSQL, followed by the name of the report before the SQL file extension.

Installation:

Download the ZIP file associated with the report that the tool tip indicates contains "additional downloads" to the machine where the database resides. The "additional downloads" are the SQL files. Extract the files contained in the ZIP file.

PostgreSQL Environments

  1. Open pgAdmin PostgreSQL Tools.
  2. Connect to the server that hosts the Identity Governance database.
  3. Select the igops database.
  4. Navigate to igops > Schemas > public > Views.
  5. Open an instance of the Query Tool.
  6. Drag and drop or copy the contents of the SQL file for PostgreSQL to the SQL Editor in the Query Tool.
  7. Execute the query.

Oracle Environments

  1. Open Oracle SQL Developer.
  2. Connect to the server that hosts the Identity Governance database.
  3. Select the Views.
  4. Open an SQL Worksheet.
  5. Drag and drop or copy the contents of the SQL file for Oracle to the Worksheet.
  6. Click Run Script.

NOTE: A data collection might have to be done in order to view changes that have been made.


File Contents

Separation-of-Duties-Open-Violations-Details_2.5.1.2.zip

Files Included
ReadMe.html
or-separation_of_duties_open_violations_details.sql pg-separation_of_duties_open_violations_details.sql

License Information

By downloading or using this software, you agree that any add-on, update, mobile application, module, adapter, patch or support release (each an "Additional Release") to the software that you may download or receive that is not accompanied by a license agreement is governed by the end user license agreement that accompanied the primary product to which the Additional Release applies. You must have validly licensed the version and quantity of the primary product in order to install or use the Additional Release.