`information_schema.table_privileges.privilege_type`

mysql

type: VARCHAR NOT NULL

5.7-8

type: NULL

Note:

One of SELECT, INSERT, UPDATE, REFERENCES, ALTER, INDEX, DROP or CREATE VIEW.

5.1-10.8

type: VARCHAR NOT NULL

Note:

One of SELECT, INSERT, UPDATE, REFERENCES, ALTER, INDEX, DROP or CREATE VIEW.

type: CHARACTER_DATA NULL

Note:

Type of the privilege: SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, or TRIGGER

10-15

type: CHARACTER_DATA

Note:

Type of the privilege: SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, or TRIGGER

8.4-9.6

Note:

Type of the privilege: SELECT, DELETE, INSERT, UPDATE, REFERENCES, or TRIGGER

8.2-8.3

Note:

Type of the privilege: SELECT, DELETE, INSERT, UPDATE, REFERENCES, RULE, or TRIGGER

7.4-8.1

type: unknown

Note:

Type of privilege: SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, or TRIGGER.

1-21.2

type: VARCHAR(10) NULL

Note:

Type of privilege.