Informix Error -24146: Username and rolename have conflicting permissions.
Cause and resolution
Username and rolename have conflicting permissions.
During the execution of the MOVE TABLE command, one of the following situations may have occurred:
* A rolename in the source database conflicts with a username in the destination database * A username in the source database conflicts with a rolename in the destination database.
To correct this error: * Do not use the ROLES option in the WITH clause of a MOVE TABLE command * Do not use the WITH clause with the MOVE TABLE command * Revoke these conflicting permissions manually before executing a MOVE TABLE command.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24146 fires during MOVE TABLE when a rolename in the source database conflicts with a
username in the destination database, or vice versa — per the official guidance.
- A rolename in the source database matching a username in the destination database, per the official guidance — the first named case.
- A username in the source database matching a rolename in the destination database, per the official guidance — the second named case.
Solutions / Resolution
- Don't use the
ROLESoption in theMOVE TABLEcommand'sWITHclause, per the official guidance, or - Don't use the
WITHclause at all, per the official guidance, or - Manually revoke the conflicting permissions before executing
MOVE TABLE, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a username/rolename conflict between databases.
Diagnostic Checks
- Check for a username/rolename overlap between the source and destination
databases, and revoke the conflicting permission or drop the
WITH/ROLESclause.
Related Errors / Related Topics
- -24145 — "Only permanent(base) tables can be moved." A related
MOVE TABLEerror, on table type rather than permission conflicts. - -24147 — "Source and destination database must be different." A related
MOVE TABLEerror, on same-database moves. - -24148 — "Cannot move a table from the sysmaster and sysutils databases." A related
MOVE TABLEerror, on system-database restrictions. - -24149 — "Owner name conflicts with role name in the destination database." A
closely related
MOVE TABLEpermission conflict, specifically between the target owner name and an existing role. - -24150 — "Only users with DBA privileges can move the table." A related
MOVE TABLEerror, on privilege requirements.
A MOVE TABLE username/rolename conflicted between the source and destination
databases — drop the WITH/ROLES clause or revoke the conflicting permission first.