Roles for user groups

Products

• CA Business Service Insight

Issue/Introduction

In order to review permissions, how can a list that contains what type of roles are assigned to which user be collected from the BSI database?

Environment

CA Business Service Insight 8.3.5.x and 9.0

Resolution

The security groups are held in the t_security_groups table, with the security_group_id field mapping to the user_group_id field via the t_security_group_members table.

The t_user_group_members table will allow you to map that user_group_id to a list of user_id values.

The t_users table will tell you the user_name for a given user_id.

Depending on exact requirements, might be more interested in the user_group_name or security_group_name.