Oninit
Talk to an expert →

Informix Error -29007: RDB authorization failure. RDB-userID,RDB: RDB-userID,RDB-name.

Cause and resolution

RDB authorization failure. RDB-userID,RDB: RDB-userID,RDB-name.

The user is not authorized to access the target RDB. The request is rejected.

Contact the DBA of the RDB side if necessary. Correct the authorization problem and rerun the application program.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29007 fires when the connecting user isn't authorized to access the target remote database (RDB) — per the official guidance, the request is rejected.

  1. The user lacking authorization on the target RDB, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Contact the DBA on the RDB side, per the official guidance, to correct the authorization problem.
  2. Rerun the application program, per the official guidance, once authorization is corrected.
Examples
N/A

No specific triggering statement is documented beyond an authorization failure at the target RDB.

Diagnostic Checks
  1. Check the RDB-userID's authorization on the target RDB-name with the RDB-side DBA.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -29007 in this set yet.

The user wasn't authorized to access the target RDB — contact the RDB-side DBA to correct authorization.