Oninit
Talk to an expert →

Informix Error -19801: Role name cannot be <reserved word="">. </reserved>

Cause and resolution

Role name cannot be <reserved word="">. </reserved>

You cannot create a role name that is a reserved word. The reserved words are connect, resource, dba, dbsecadm, select, update, delete, insert, index, references, alter, execute, default, none, null, and public. Change the name of the role.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19801 fires when a role name is one of the reserved words — per the official guidance: connect, resource, dba, dbsecadm, select, update, delete, insert, index, references, alter, execute, default, none, null, and public.

  1. A role name matching one of the reserved words, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Change the role name to something other than a reserved word, per the official guidance.
Examples
A role name that's a reserved word
CREATE ROLE public;
-- -19801: public is reserved
Corrected
CREATE ROLE reader_role;
Diagnostic Checks
  1. Check the intended role name against the reserved-word list (connect/resource/dba/dbsecadm/select/update/delete/insert/index/ references/alter/execute/default/none/null/public).
Related Errors / Related Topics
  • -19800 — "Role name already exists as a user or role." A related role-naming restriction, about a collision with an existing name rather than a reserved word.

A role name is a reserved word — choose a different name.