What does HRESULT 0x87AF0017 (SQLITE_E_AUTH) mean?

 
Previous Next
SQLITE_E_NOLFS SQLITE_E_FORMAT

SQLITE_E_AUTH

SQLITE_E_AUTH corresponds to SQLite SQLITE_AUTH. An SQLite authorizer callback rejected an attempted SQL operation.

What to check for SQLITE_E_AUTH

  • Identify the connection-level authorizer policy and log the action, object name, and context that it rejected.
  • Check generated SQL from plugins or user-provided expressions, because policy can block operations that are not obvious in high-level code.
  • Change authorization rules narrowly; do not disable the authorizer globally merely to make one statement succeed.
SELECT sqlite_version();

SQLite: Result and Error Codes

Diagnostic discriminator: Trace the SQLite authorizer callback and the operation it denied. This status is an authorization callback rejection, distinct from SQLITE_PERM and from extension-defined IOERR_AUTH.


Looking for a different code? Search another status or error code.