Page tree
Skip to end of metadata
Go to start of metadata

Unsupported Privileges

The following privileges are not supported, and generate a syntax error if used in a GRANT statement:

  • CREATE ROUTINE
  • EVENT

Ignored Privileges

The following privileges are ignored:

  • ALTER ROUTINE
  • CREATE TEMPORARY TABLES
  • FILE
  • LOCK TABLES
  • PROCESS
  • REFERENCES
  • RELOAD
  • SHOW DATABASES
  • SHOW VIEW
  • SHUTDOWN

Other Differences

The _ and % wild cards are not supported in database name specifications.

The GRANT statement ignores REQUIRE, if included.

The DEFINER and SQL SECURITY arguments for views are ignored.

The following GRANT WITH options are not supported and generate a syntax error:

  • MAX_QUERIES_PER_HOUR
  • MAX_UPDATES_PER_HOUR
  • MAX_CONNECTIONS_PER_HOUR
  • MAX_USER_CONNECTIONS

RENAME USER, CURRENT_USER, CURRENT_USER() and SESSION_USER() are not supported.

The SUPER permission grants all privileges associated with the TRIGGER permission.

  • No labels