Only directly assigned single and composite roles are mapped in SAPUserInSAPRole. Assignments of single roles to composite roles are mapped in SAPCollectionRPG. You can establish which single roles are indirectly assigned to a user account through both tables.
The following applies by default for the inheritance of single roles by user accounts: If a single role is assigned to a user account and this single role is part of a composite role that is also assigned to the user account, then the assignment of the single role is additionally mapped in the SAPUserInSAPRole table if the validity period of the assigned single and composite role is not identical.
To not map memberships in single roles in the SAPUserInSAPRole table if the single roles are part of assigned composite roles
-
In the Designer, disable the TargetSystem | SAPR3 | KeepRedundantProfiles configuration parameter.
The table contains only the membership in the composite role.
Effect of the KeepRedundantProfiles configuration parameter
A single role is assigned to a user account, as well as a composite role that contains this single role.
-
The configuration parameter is set. Both role assignments have a different validity period.
The SAPUserInSAPRole table contains both the composite role assignment and the single role assignment.
-
The configuration parameter is set. Both role assignments have the same validity period.
The SAPUserInSAPRole table contains only the assignment of the composite role.
-
The configuration parameter is not set.
The SAPUserInSAPRole table contains only the assignment of the composite role. This applies regardless of the validity period of either role assignment.