information_schema系统表——COLUMN_PRIVILEGES

最新推荐文章于 2022-08-20 12:11:00 发布

原创最新推荐文章于 2022-08-20 12:11:00 发布 · 612 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#information_schema #column_privileges

mysql 专栏收录该内容

24 篇文章

订阅专栏

本文介绍了来自mysql.columns_priv权限表的列权限信息详情。通过INFORMATION_SCHEMA.COLUMNS_PRIVILEGES表可以查询特定用户的列级权限，包括SELECT、INSERT、UPDATE、REFERENCES等类型，并展示了如何判断用户是否拥有GRANT OPTION权限。

该表提供了有关列权限信息，这些信息来自mysql.columns_priv权限表

The COLUMN_PRIVILEGES table provides information about column privileges. This information comes from the mysql.columns_priv grant table.

`INFORMATION_SCHEMA` Name	`SHOW` Name	Remarks
`GRANTEE`		`'user_name'@'host_name'` value
`TABLE_CATALOG`		`def`
`TABLE_SCHEMA`
`TABLE_NAME`
`COLUMN_NAME`
`PRIVILEGE_TYPE`
`IS_GRANTABLE`

Notes:

In the output from SHOW FULL COLUMNS, the privileges are all in one field and in lowercase, for example, select,insert,update,references. In COLUMN_PRIVILEGES, there is one privilege per row, in uppercase.
PRIVILEGE_TYPE can contain one (and only one) of these values: SELECT, INSERT, UPDATE, REFERENCES.
If the user has GRANT OPTION privilege, IS_GRANTABLE should be YES. Otherwise, IS_GRANTABLE should be NO. The output does not list GRANT OPTION as a separate privilege.