MariaDB/SQL/GRANT

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MariaDB‎ | SQL
Revision as of 17:54, 16 February 2025 by Woozle (talk | contribs) (Created page with "==Syntax== * <code>GRANT</code> {{fmt/arg|priv list}} <code>ON</code> {{fmt/arg|object type}} {{fmt/arg|priv level}} <code>TO</code> {{fmt/arg|user spec}} [ {{fmt/arg|user opt...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Syntax

  • GRANT <priv list> ON <object type> <priv level> TO <user spec> [ <user options> ]
    • <priv list>: <priv_type> [ <column_list> ] [, repeat...]
    • <object type>: one of –
      • TABLE
      • FUNCTION
      • PROCEDURE
      • PACKAGE
      • PACKAGE BODY
    • <priv level>: one of –
      • *
      • *.*
      • <db_name>.*
      • <db_name>.<tbl_name>
      • <tbl_name>
      • <db_name>.<routine_name>
    • <user spec>: one of –
      • <username> [ <authentication option> ]
      • PUBLIC
    • [ <authentication option> ]: one of –
      • IDENTIFIED BY '<password>'
      • IDENTIFIED BY PASSWORD 'password_hash'
      • IDENTIFIED {VIA|WITH} <authentication rule> [OR repeat...]
  • GRANT <rolename> TO <grantee> [, repeat...] [WITH ADMIN OPTION]
    • <grantee>: one of –
      • <rolename>
      • <username> [ <authentication option> ]
Retrieved from "https://htyp.org/mw/index.php?title=MariaDB/SQL/GRANT&oldid=29072"