Skip to main content
OCLC Support

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
49349