WGN_V_USER_HIST

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

WGN_V_USER_HIST_1

This view returns all columns from Wgn3User similar to WGN_V_USER_1 subject to RLS being applied. WGN_V_USER_1 returns rows by strictly applying RLS so that only current users, subject to RLS, will be returned. WGN_V_USER_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_1.

View Stack


WGN_V_USER_HIST_1
→	WGN_V_m_USER_HIST_1
	→	wgn_v_md_user_hist_1
		→	WGN3USER
			WGN3USERGROUP
			WGN_V_RLS_1
			→	TMP_WGN3RLS

Column Details

Column	Data Type	Length	Description
UserIDM	INTEGER	4	Part-key identifying the CA Data Protection user associated with the login.
UserID	INTEGER	4	Part-key identifying the CA Data Protection user associated with the login.
UserName	VARCHAR	64	The name of the CA Data Protection 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 Data Protection user was created.
UserRole	INTEGER	4	The CA Data Protection 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 Data Protection privileges the user is allowed to perform. The initial value is taken from the 'privilege profile' associated with the user's role.