Informix Error -24150: Only users with DBA privileges can move the table.
Cause and resolution
Only users with DBA privileges can move the table.
Only users with DBA privileges on both the source and destination databases are allowed to execute the MOVE TABLE statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24150 fires when a non-DBA user executes MOVE TABLE — per the official guidance, DBA
privileges on both the source and destination databases are required.
- A user lacking DBA privileges on the source and/or destination database executing
MOVE TABLE, per the official guidance — the direct, only cause.
Solutions / Resolution
- Have a user with DBA privileges on both databases execute the
MOVE TABLEstatement, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a non-DBA user attempting the move.
Diagnostic Checks
- Check the executing user's DBA privileges on both the source and destination databases, and have a suitably privileged user run the statement instead.
Related Errors / Related Topics
- -24145 — "Only permanent(base) tables can be moved." A related
MOVE TABLEerror, on table type rather than privileges. - -24146 — "Username and rolename have conflicting permissions." A related
MOVE TABLEerror, on 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
related
MOVE TABLEerror, on owner/role-name conflicts.
MOVE TABLE requires DBA privileges on both the source and destination databases — have a
suitably privileged user run it.