本文主要是介绍information_schema系统表——COLUMN_PRIVILEGES,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
该表提供了有关列权限信息,这些信息来自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 | ' 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
. InCOLUMN_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 beYES
. Otherwise,IS_GRANTABLE
should beNO
. The output does not listGRANT OPTION
as a separate privilege.
这篇关于information_schema系统表——COLUMN_PRIVILEGES的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!