Skip to main content

Db2_EffectivePermissions Job

This job provides insight into effective user and role permissions to all the database objects in the targeted Db2 database servers.

Analysis Tasks for the Db2 _EffectivePermissions Job​

Navigate to the Jobs > Databases > Db2 > Permissions > Db2_EffectivePermissions > Configure node and select Analysis to view the Analysis Tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Tasks for the Db2 _EffectivePermissions Job

The default analysis tasks are:

  • Effective Permissions – Uses role membership to display effective permissions on Db2 objects
  • Database Summary – Summarizes effective permissions by Db2 database

Report for the Db2_Effective Job​

In addition to the tables and views created the analysis task, the Db2_EffectivePermissions job produces the following preconfigured report.

ReportDescriptionDefault TagsReport Elements
Effective PermissionsThis report shows details on effective permissions in the audited Db2 environment.NoneThis report is comprised of three elements: - Bar Chart – Displays Database Summary - Table – Displays Database Summary - Table – Displays permissions details