WGN_V_USER_GROUP_HIST

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

WGN_V_USER_GROUP_HIST_1

This view returns the same columns as WGN_V_USER_GROUP_1 subject to RLS being applied. WGN_V_USER_GROUP_1 returns rows by strictly applying RLS so that only current users, subject to RLS, will be returned. WGN_V_USER_GROUP_HIST_1 additionally returns records for users that were, historically, in the logged on user's management group but have since moved and would therefore not be seen via WGN_V_USER_GROUP_1.

View Stack


WGN_V_USER_GROUP_HIST_1
→	wgn_v_m_user_group_hist_1
	→	wgn_v_md_user_group_hist_1
		→	WGN3USERGROUP
			WGN_V_RLS_1
			→	TMP_WGN3RLS
			WGN3USER
			WGNGROUP

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 policy document for this user.
GroupPolicyID	INTEGER	4	Part-key identifying the policy document for this user.
GroupDeletedFlag	BIT	1	Indicates whether the user/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 groups parent
parentgroupid	INTEGER	4	Part-key identifying the child groups 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.