EC
1374
MySQLerrorpermissionshigh confidence

Illegal GRANT/REVOKE for table

Production Risk

Low — GRANT fails; no privileges are changed.

What this means

A GRANT or REVOKE specified a privilege that is not applicable at the table level (e.g. granting CREATE on a specific table).

Why it happens
  1. 1Using database-level privileges (CREATE, DROP) in a table-level GRANT
  2. 2Mixing column-level and table-level privileges incorrectly
How to reproduce
trigger — this will error
trigger — this will error
GRANT CREATE ON db.my_table TO 'user'@'host';

expected output

ERROR 1374 (HY000): Illegal GRANT/REVOKE command; please consult the manual for which privileges can be used at table level

Fix

Use the correct privilege scope

Use the correct privilege scope
GRANT CREATE ON db.* TO 'user'@'host';

Why this works

CREATE is a database-level privilege; grant it on the schema.

Sources
Official documentation ↗

MySQL 8.0 — 1374 ER_ILLEGAL_GRANT_FOR_TABLE

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors