Oninit
Talk to an expert →

Informix Error -8230: User <user-name> does not have the authority to grant or </user-name> revoke DBSECADM.

Cause and resolution

User <user-name> does not have the authority to grant or </user-name> revoke DBSECADM.

Only the DBSA has the authority to grant or revoke DBSECADM privilege. Contact the DBSA to perform this operation.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8230 fires when a non-DBSA user attempts to grant or revoke DBSECADM — per the official guidance, only the DBSA has this authority.

  1. The user isn't the DBSA, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Contact the DBSA to perform this operation, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a non-DBSA user granting/revoking DBSECADM.

Diagnostic Checks
  1. Confirm the current user is the DBSA, and have the DBSA perform the grant/revoke if not.
Related Errors / Related Topics
  • -8200 — "User does not have DBSECADM authority." A related LBAC authority error, about lacking DBSECADM itself rather than the authority to grant/ revoke it.

A non-DBSA user attempted to grant/revoke DBSECADM — only the DBSA can do this.