Specifications

Grant_priv enum(‘N’,’Y’)
References_priv enum(‘N’,’Y’)
Index_priv enum(‘N’,’Y’)
Alter_priv enum(’N’,’Y’)
TABLE 11.3 Schema of the host Table in the mysql database
Field Type
Host char(60)
Db char(64)
Select_priv enum(‘N’,’Y’)
Insert_priv enum(‘N’,’Y’)
Update_priv enum(‘N’,’Y’)
Delete_priv enum(‘N’,’Y’)
Create_priv enum(‘N’,’Y’)
Drop_priv enum(‘N’,’Y’)
Grant_priv enum(‘N’,’Y’)
References_priv enum(‘N’,’Y’)
Index_priv enum(‘N’,’Y’)
Alter_priv enum (‘N’,’Y’)
The tables_priv and columns_priv Tables
These two tables are used to store table-level privileges and column-level privileges, respec-
tively. They work like the db table, except that they provide privileges for tables within a spe-
cific database and columns within a specific table respectively.
These tables have a slightly different structure to the user, db, and host tables. The schemas
for the tables_priv table and the columns_priv table are shown in Tables 11.4 and 11.5,
respectively.
Advanced MySQL
C
HAPTER 11
11
ADVANCED
MY
SQL
249
TABLE 11.2 Continued
Field Type
14 7842 CH11 3/6/01 3:35 PM Page 249