Add the user to TFs licensed users

The user who uses TFs must be a member of the team Foundation licensed users group. This group has 5 users. According to the information on the Internet, you can modify the TFS database to break the 5 User restrictions. The following SQL statement can be used to add domain users to the licensed users group:

 

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] = N'Domain Users'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 ())

* The red font indicates the username you want to add. It can also be the group name.

The problem is that after a new member joins the domain user group, TFS does not automatically update the employee. One way is to manually update the tbl_security_membership_cache relational table, which is troublesome. (I haven't found any update method for this manual update cache table. If you know it, leave a message. I am waiting for a while to let him update the cache table .) Another way is to create a user group in TFs, such as a "new member" group. Use the preceding statement to add the group to the licensed users group. After a new employee arrives, add the user to the "new member" group.