Adding, Editing and Deleting SQL User Information

You must manually add users to the SQLUM tables. For security purposes, K2 provides a stored procedure which encrypts the passwords.

1. Open Microsoft SQL Server Management Studio.
2. Connect to the server where the K2 database is installed.
3. Expand the K2 database (K2 is the default).
4. Browse to the following path: K2 > Programmability > Stored Procedure
5. Find CustomUM.CreateUser, right click and select Execute Stored Procedure.
   
6. Enter the user's details on the Execute Procedure dialog.
   

To add a user to a group, you need to first create the group in the database and then add the user to that group. Create the group manually by following these steps:

1. Open Microsoft SQL Server Management Studio.
2. Connect to the server where the K2 database is installed.
3. Expand the K2 database (K2 is the default).
4. Right click on CustomUM.Group and select Edit Top 200 Rows.
5. Enter the group details into the table (GroupID is automatically generated when you save your changes).
   
   
6. Next you add users to the group. Right click on CustomUM.UserGroup and select Edit Top 200 Rows.
7. Enter the GroupID (from CustomUM.Group entry you created) and the UserID (from CustomUM.Users, the stored procedure you ran when creating the user creates the ID) into the table and save your changes to the database.
   

To add a SQL user to a role, add the user to the role through K2 Management site > Users node > Roles. You must have administrator privileges to do this.

To edit a user's UserName, UserDescription, UserEmail, ManagerID or DisplayName, edit the relevant row in the CustomUM.User table.

To change a user's password, execute the CustomUM.SetPassword stored procedure and enter the Username and the new Password for the user whose password you want to change. The stored procedure will encrypt the new password.