Informix Error -3421: The joined field table.column cannot be selected by the current user.

Cause and resolution

The joined field table.column cannot be selected by the current user.

This form queries the column in the table shown in joining two tables. However, your account name does not have SELECT privilege for that table and column. Contact the owner of the table or a Database Administrator to be given this privilege.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3421 fires when the current account lacks SELECT privilege on a table/column used in a form join — per the official guidance, the form queries that column while joining two tables, but the account doesn't have SELECT privilege for it.

The account lacks SELECT privilege on the joined table/column, per the official guidance — the direct, only cause.

Solutions / Resolution

Contact the owner of the table or a Database Administrator to be granted SELECT privilege, per the official guidance.

Examples

Granting SELECT privilege

GRANT SELECT ON customer TO myaccount;

Diagnostic Checks

Check whether the current account has SELECT privilege on the joined table, and request it from the table owner or a DBA if missing.

Related Errors / Related Topics

-3700 — "Permission not granted to allow reading of table-name." A related SELECT-privilege error, about the table as a whole rather than one joined column specifically.

The current account lacks SELECT privilege on a joined table/column — request it from the table owner or a DBA.