WGN_V_USER

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

WGN_V_USER_1

This view returns all columns from Wgn3User subject to RLS being applied. This view should always be used when a search wants to retrieve information from Wgn3User. If a search attempts to retrieve rows directly from Wgn3User the search will fail as the search user will not have permission to select data from this table directly.

View Stack


wgn_v_user_1
→	wgn_v_m_user_1
	→	wgn_v_md_user_1
		→	WGN3USER
			WGN3USERGROUP
			WGN_V_RLS_1
			→	TMP_WGN3RLS

Column Details

Column	Data Type	Length	Description
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.