Informix Error -19808: User name already exists as a rolename in the database.
Cause and resolution
User name already exists as a rolename in the database.
A user cannot open a database as a role name that is the same as the user name. Role names and user names must be unique in the database. If you want to access the database, contact the DBA of the database. The DBA can drop the role if necessary.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-19808 fires when a user opens a database and their username collides with an existing role name — per the official guidance. Role names and user names must be unique in the database.
- A user's own name colliding with an existing role name, per the official guidance — the direct, only cause.
Solutions / Resolution
- Contact the DBA of the database, per the official guidance — the DBA can drop the conflicting role if necessary.
Examples
N/A
No specific triggering statement is documented beyond a username/rolename collision.
Diagnostic Checks
- Check
informix.sysusersfor a role matching the username, and have the DBA resolve the collision.
Related Errors / Related Topics
- -19800 — "Role name already exists as a user or role." The mirror-image condition, at role-creation time rather than database-open time.
A username collides with an existing role name — contact the DBA to resolve it.