information_schema系统表——COLUMN_PRIVILEGES

最新推荐文章于 2024-06-24 23:09:23 发布

问题不大的

最新推荐文章于 2024-06-24 23:09:23 发布

阅读量588

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签： information_schema column_privileges

本文链接：https://blog.youkuaiyun.com/db2china/article/details/78541519

mysql 专栏收录该内容

24 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

该表提供了有关列权限信息，这些信息来自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.