WGN_V_USER_GROUP

Database Schema and Views Reference Guide › Database Views › Primary Views Definitions › WGN_V_USER_GROUP_1

WGN_V_USER_GROUP_1

This view returns all columns from WgnGroup, plus the parent group id's associated with each group, and all columns from Wgn3User subject to RLS being applied. This view should be used if you require both user and group information. It would be possible to get the same information from Wgn_V_User_1 and Wgn_V_Group_1, however you would apply RLS twice (as you are unable to reference the underlying table directly) if you choose this option. This view allows easy access to user and group information but only applies RLS once.

View Stack


wgn_v_user_group_1
→	wgn_v_m_user_group_1
	→	wgn_v_md_user_group_1
		→	wgn_v_md_group_1
			→	WGNGROUP
				WGN_V_RLS_1
				→	TMP_WGN3RLS
			WGN3USER
			WGN3USERGROUP

Column Details

Column	Data Type	Length	Description
GroupIDM	INTEGER	4	Part-key used to uniquely identify a group within the installation.
GroupID	INTEGER	4	Part-key used to uniquely identify a group within the installation.
GroupName	VARCHAR	64	The group name.
GroupPolicyIDM	INTEGER	4	Part key identifying the groups policy document.
GroupPolicyID	INTEGER	4	Part key identifying the groups policy document.
GroupDeletedFlag	BIT	1	Indicates whether the group is deleted or not.
GroupCreateTime	TIMESTAMP	8	The time that the CA DataMinder group was created.
ParentGroupIDM	INTEGER	4	Part-key identifying the child group's parent
ParentGroupID	INTEGER	4	Part-key identifying the child group's parent
UserIDM	INTEGER	4	Part-key identifying the CA DataMinder user associated with the login.
UserID	INTEGER	4	Part-key identifying the CA DataMinder user associated with the login.
UserName	VARCHAR	64	The name of the CA DataMinder user. The naming convention (if any) depends on the user creation policy settings.
PolicyIDM	INTEGER	4	Part-key identifying the policy document for this user.
PolicyID	INTEGER	4	Part-key identifying the policy document for this user.
UserCreateTime	TIMESTAMP	8	The time that the CA DataMinder user was created.
UserRole	INTEGER	4	The CA DataMinder role assigned to the user. This is used to determine the user's initial privileges.
DeletedFlag	BIT	1	Indicates whether the user/group is deleted or not.
UserData	VARBINARY	255	Salt used to hash the password.
PasswordHash	VARBINARY	255	A hashed copy of the user's password.
UserPrivileges	DECIMAL	13	A bitmap of CA DataMinder privileges the user is allowed to perform. The initial value is taken from the 'privilege profile' associated with the user's role.