Role and Power Details report does not show nested roles in the Report. (NETIQKB39966)

  • 7739966
  • 02-Feb-2007
  • 19-Jun-2007

Resolution

fact
Directory and Resource Administrator 6.60

fact
Directory and Resource Administrator 7.0

fact
Directory and Resource Administrator 7.0 SP1

symptom
Role and Power Details report does not show nested roles in the Report.

cause
The issue is due to the query for the Role and Power Details Report not including nest rolls.

fix

This is corrected in DRA 7.5 and later. To resolve this issue upgrade to the latest version of DRA.

Below is a workaround that will show the nested roles inside roles.  It will show the first level of nested roles in the Role and Power Details report.   If a role has a nested role, then the nested role name will show up as "Role: <rolename>" in the Powers column of the report.  This gives the same funtionality of what is displayed in the Delegation and Configuration console.   To apply this:

1.  Open the Directory and Resource Administrator (DRA) Reporting tool.
2.  Select File | Enter Design mode.
3.  Click on the Query tab.
4.  Double-click on the query qryRolesAndPowerDetails.
5.  Select View | SQL View.
6.  Replace the qryRolesAndPowerDetails query with this one:

SELECT ROLES.McsName, ROLES.McsNameValue, ROLES.McsClass, ROLE_POWER_BINDINGS.POWER_NAME
FROM ROLES INNER JOIN ROLE_POWER_BINDINGS ON ROLES.ROLE_ID = ROLE_POWER_BINDINGS.ID

UNION ALL SELECT ROLES.McsName, ROLES.McsNameValue, ROLES.McsClass, "Role: " & ROLES_1.McsNameValue AS POWER_NAME
FROM (ROLES INNER JOIN ROLE_BINDINGS ON ROLES.ROLE_ID = ROLE_BINDINGS.ID) INNER JOIN ROLES AS ROLES_1 ON ROLE_BINDINGS.ASSOC_ID = ROLES_1.ROLE_ID;



Additional Information

Formerly known as NETIQKB39966