Adding, Editing and Deleting SQL User Information

You use SQL stored procedures to add, edit and delete users stored in the database. Note that you must have Administrative privileges to run these stored procedures.

The following three tables, listed here with their fields, store all information for the SQLUM:

CustomUM.User

  • UserID
  • UserName
  • UserPassword
  • PasswordHash
  • UserDescription
  • UserEmail
  • ManagerID
  • DisplayName
  • FailedLoginAttempts
  • LastLoginAttempt
  • ExcludeFromLockoutPolicy

CustomUM.Group

  • GroupID
  • GroupName
  • GroupDescription

CustomUM.UserGroup

  • GroupID
  • UserID

You may want to edit these tables directly, but K2 recommends that you use the stored procedures to add, edit and delete users from the tables.

You may notice that the User table includes information about the user's manager. This is useful in cases where you need to assign tasks to the originator's manager, such as in a Leave Approval app, for the manger to action. Both the manager and the user need to have accounts in SQL. The users ManagerID field is the UserID field of his or her manager.

If you need to remove a SQL user, please contact support for instructions.

See the following topics for more information about SQLUM: