Solved

Removed User

  • 12 August 2020
  • 3 replies
  • 153 views

Badge +4

I was in Managerment and I removed a user in error. Can anybody advise how I can add the user back.

 

Regards 

AndyR

icon

Best answer by HulisaniN 17 August 2020, 15:39

Hi  @AndyR1 


 


From the research I did, I dont think possible to add a user since the Users view displays users who's credentials are cached (users who have connected to K2). This just frees up licenses for other users.


 


You can read more on this via the link below:


https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#K2-Management-Site/Licenses/Licenses.htm


 


I also check the DB to see if I couldn't add a user from there and unfortunately I can't add since they need LicensesUserID and CredentialID which are of data type uniqueidentifier. You can have a look on the attachment 20200817.


Sql script:


/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [LicensedUserID]
,[LicenseID]
,[CredentialID]
,[TempFQN]
,[UserType]
FROM [K2].[HostServer].[LicensedUser]

Regards


HulisaniN

View original

3 replies

Userlevel 3
Badge +10

Hi AndyR,

May I know where in Management was the user removed from?


Badge +4

I went in to management, the Licences and then the Users section. I highlighted the User name and clicked remove

 

Regards

 

AndyR 

Userlevel 2
Badge +4

Hi  @AndyR1 


 


From the research I did, I dont think possible to add a user since the Users view displays users who's credentials are cached (users who have connected to K2). This just frees up licenses for other users.


 


You can read more on this via the link below:


https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#K2-Management-Site/Licenses/Licenses.htm


 


I also check the DB to see if I couldn't add a user from there and unfortunately I can't add since they need LicensesUserID and CredentialID which are of data type uniqueidentifier. You can have a look on the attachment 20200817.


Sql script:


/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [LicensedUserID]
,[LicenseID]
,[CredentialID]
,[TempFQN]
,[UserType]
FROM [K2].[HostServer].[LicensedUser]

Regards


HulisaniN

Reply