`information_schema.column_privileges.privilege_type`

mysql

type: VARCHAR NOT NULL

5.7-8

type: NULL

Note:

One of SELECT, INSERT, UPDATE or REFERENCES.

5.1-10.8

type: VARCHAR NOT NULL

Note:

One of SELECT, INSERT, UPDATE or REFERENCES.

type: CHARACTER_DATA NULL

Note:

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

10-15

type: CHARACTER_DATA

Note:

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

7.4-9.6

type: unknown

Note:

Name of the privilege.

2-21.2

type: VARCHAR(10) NULL

Note:

Type of privilege.