Informix Error -4511: A temporary table needed for a report could not be created in the selected database. The user must have permission to create tables in the selected database.
Cause and resolution
A temporary table needed for a report could not be created in the selected database. The user must have permission to create tables in the selected database.
See error -1328, which has replaced this error.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-4511 is a legacy code — per the official guidance, it has been replaced by error -1328. See
-1328 for the current documentation of this condition: a report's
temporary working table couldn't be created, typically because the connected user lacks
CREATE TABLE permission in the selected database.
- This exact wording is superseded, per the official guidance — -1328 now covers the same underlying condition.
Solutions / Resolution
- Treat this as -1328 and apply that code's resolution steps, per the official guidance.
Examples
N/A
No triggering example is documented separately from -1328 — see that code for worked examples of the underlying permission failure.
Diagnostic Checks
- Confirm the environment/version reporting -4511 rather than -1328, and refer to -1328 for the actual diagnostic steps.
Related Errors / Related Topics
- -1328 — "A temporary table needed for a report could not be created in the selected database. The user must have permission to create tables in the selected database." The current, active code that has replaced -4511.
-4511 has been replaced by -1328 — refer to that code for the current documentation of this temporary-table permission failure.