User_roles_in_spaces

Definition

CREATE   VIEW
  [sec].[User_roles_in_spaces] AS
SELECT DISTINCT
  [u].[User_Id],
  [u].[Name],
  [u].[Login],
  [u].[Email],
  [u].[Is_Group],
  CAST([u].[Created] AS DATE) [Created],
  [u].[Is_Deleted],
  CASE [ro].[Name]
    WHEN 'enum.role.viewer.name' THEN 'Viewer'
    WHEN 'enum.role.contributor.name' THEN 'Contributor'
    WHEN 'enum.role.admin.name' THEN 'Admin'
  END [Role],
  [u].[Description]
FROM
  [dbo].[APP_User] [u]
  LEFT JOIN [dbo].[APP_Role] [ro]  ON [ro].[Role_Id] = [u].[Role_Id]

Columns

#	Column	Data Type	Nullable	Source
1	User_Id	int	No	APP_User.User_Id
2	Name	nvarchar	No	APP_User.Name
3	Login	nvarchar	Yes	APP_User.Login
4	Email	varchar	Yes	APP_User.Email
5	Is_Group	bit	No	APP_User.Is_Group
6	Created	date	Yes	APP_User.Created
7	Is_Deleted	bit	No	APP_User.Is_Deleted
8	Role	varchar	Yes	APP_Role.Name
9	Description	nvarchar	Yes	APP_User.Description

graph LR
  n1555["User_roles_in_spaces"]
  n1262["APP_Role"]
  n1288["APP_User"]
  n1262 --> n1555
  n1288 --> n1555
  style n1555 fill:#00A081,stroke:#008068,color:#fff
  click n1555 href "/actual/userrolesinspaces/"
  click n1262 href "/actual/approle/"
  click n1288 href "/actual/appuser/"