I can't delete one or more ILLiad users using the Database Manager

Symptom

• Users with usernames like illiaduser', screamin’jayhawkins, or lupitanyong'o are not deleting even though they have no transactions.

Applies to

• ILLiad

Resolution

The Database Manager uses SQL to delete users, but apostrophes are used in SQL language. Having a username with an apostrophe causes the scripts it uses to fail. Here's what you can do:

• If OCLC hosts your institution, contact OCLC Support.
• If your institution is self-hosted, contact your database administrator or IT department. They will need to run a SQL Query to delete the user by some other characteristic than the username, such as email address.

Page ID