TFS2008 突破5用户限制
TFS2008 Listened user组织能加5个用户,这个限制会只有5个用户可以访问TFS,使用下面的存储过程可以给Listened user组怎就用户,而且不受系统限制
declare @user varchar(100)
set @user='Zhou hao'
declare @container varchar(100),@member varchar(100)
SELECT @container=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache] where [display_name]=N'Team Foundation Licensed Users' and deleted=0
SELECT @member=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache] where [display_name]=@user and deleted=0
Insert [TfsIntegration].[dbo].[tbl_security_membership_cache]([container],[member]) values
(@container,@member)
Insert [TfsIntegration].[dbo].[tbl_gss_group_membership]([parent_group_sid], [member_sid], [last_update])
values(@container, @member, getdate())
set @user='Zhou hao'
declare @container varchar(100),@member varchar(100)
SELECT @container=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache] where [display_name]=N'Team Foundation Licensed Users' and deleted=0
SELECT @member=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache] where [display_name]=@user and deleted=0
Insert [TfsIntegration].[dbo].[tbl_security_membership_cache]([container],[member]) values
(@container,@member)
Insert [TfsIntegration].[dbo].[tbl_gss_group_membership]([parent_group_sid], [member_sid], [last_update])
values(@container, @member, getdate())