Informix Error -3700: Permission not granted to allow reading of table-name.

Cause and resolution

Permission not granted to allow reading of table-name.

Your account has not been granted SELECT privilege for the table table-name. The owner of the table, or a person who has Database Administrator (DBA) privilege for the database, can grant this privilege level to you.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3700 fires when the current account lacks SELECT privilege on table-name — per the official guidance, the table's owner or a DBA can grant this privilege.

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

Solutions / Resolution

Have the table's owner or a Database Administrator grant SELECT privilege, per the official guidance.

Examples

Granting SELECT privilege

GRANT SELECT ON table-name TO myaccount;

Diagnostic Checks

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

Related Errors / Related Topics

-3421 — "The joined field table.column cannot be selected by the current user." A related SELECT-privilege error, specific to a joined column rather than the table as a whole.
-3710 — "Permission not granted to allow update of table-name." The equivalent privilege check for UPDATE rather than SELECT.
-3720 — "Permission not granted to allow add of table-name." The equivalent privilege check for INSERT rather than SELECT.

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