invalid_grant_operation Invalid Grant Operation — SQLSTATE 0LP01

The server reports SQLSTATE 0LP01 (invalid_grant_operation), a condition in the Invalid Grantor class.

• The error is written to the server log and returned to the client carrying SQLSTATE 0LP01.
• Any driver (libpq, JDBC, psycopg, npgsql, pgx) surfaces this code in its error object so you can branch on it programmatically.
• PL/pgSQL can trap it by name: EXCEPTION WHEN invalid_grant_operation THEN.

Severity: ERROR  |  PostgreSQL versions: 12, 13, 14, 15, 16, 17

Reproduce with the exact statement and read the full message in the server log (raise log_min_messages / set log_min_error_statement for more context).

0LP01 belongs to Class 0L — Invalid Grantor. In this class, the grantor or grant operation is invalid.

The first two characters (0L) identify the error class, so application code can match the whole class via 0L000 when the specific code is not needed.

Verify the granting role exists and holds the privilege WITH GRANT OPTION (admin option) before it can grant to others.

Reference: PostgreSQL error codes — Class 0L (Invalid Grantor).