Unable to Delete Internal Users in Knowledgebase

almost 14 years ago | Article no. 1965

0 ratings

THIS ARTICLE APPLIES TO:

Knowledgebase version 8.x

ISSUE DESCRIPTION:

Updating an older version of Knowledgebase to 8.x prevents Administrators from deleting Internal Users.

ROOT CAUSE:

SOLUTION OR WORK AROUND:

A Database Administrator can remove Internal Users by directly accessing the database:

Using Query Analyzer, run the follwoing query. This query tells which users are active.
- Use ecrmUser
- Select * from dbo.tb_usrUser where Use_type = '1'
Make a note of the IDs (use_id) of the users that you want to be able to delete.
Use the following update query to replace data for use_id column for the users indicated. You will need to duplicate the query changing the variable for each ID.
- Update dbo.tb_usrUser set Use_type = null where use_id = 'USE_ID' (USE_ID is the ID from step 2).

Important Note: This information is intended for use by a SQL Database Administrator or other individuals with excellent technical knowledge of SQL.

AFFECTED SYSTEMS & USERS:

Administrators.

ADDITIONAL INFORMATION:

ESCALATION PROCEDURE:

If this issue continues after following these steps, please contact our Support group at 877-373-7848 or via email at cimsupport@moxiesoft.com.