How to refer to site names, site members, and site roles from the database

Please be aware that the page you are viewing has been machine translated from Japanese into English and may contain some translation errors. If you observe any issues with the translation, please contact us.

Issue

• How do I reference a site name, site member, or site roll from the database?

Environment

• DXP 7.0+

solution

• Please refer to the site name
  "Group_.name".
• Site member names
  "Users_Groups".
  Each line is paired with a user ID and the site ID to which the user belongs.
  
  Users_Groups.groupId = Group_.groupId
  Users_Groups.userId = User_.userId
• Site member permissions
  The roles that each user has, not just Cytrol, are managed by "Users_Roles".
  Each line is paired with a user ID and the role ID to which it is assigned.
  
  Users_Roles.roleId = Role_.roleId
  Users_Roles.useId = User_.userId
  
• Roles used at the site
  are managed in the "UserGroupRole" table.respectively
  

  userId：ユーザーID
  groupId：サイトID
  roleId：ロールID

  The following is a summary of the results of the survey.
  
  You can find the corresponding roleId for "Site Administrator" in the "UserGroupRole" table and browse users and sites fromuserId,groupId.