The tables_priv, columns_priv, And procs_priv Tables

• The tables_priv, columns_priv, and procs_priv tables grant table-specific, column-specific, and routine-specific privileges.
  • Values in the scope columns of these tables can take the following forms:
    • Wildcard characters ‘%’ and ‘_’ can be used in the Host column.
      • These have the same meaning as for pattern-matching operations performed with the LIKE operator.
    • A '%' or blank Host value means "any host".
    • The Db, Table_name, and Column_name columns cannot contain wildcards or be blank.

• The server sorts the tables_priv, columns_priv, and procs_priv tables based on the Host, Db, and User columns.
  • This is similar to db table sorting, but simpler because only the Host column can contain wildcards.

How does the server check privileges for database-related requests?

---

---

© 2007 John Michael Pierobon

Notes