information_schema系统表——USER_PRIVILEGES

用户权限

The USER_PRIVILEGES table provides information about global privileges. This information comes from the mysql.user grant table.

INFORMATION_SCHEMA NameSHOW NameRemarksGRANTEE 'user_name'@'host_name' value, MySQL extensionTABLE_CATALOG def, MySQL extensionPRIVILEGE_TYPE MySQL extensionIS_GRANTABLE MySQL extension

Notes:

• This is a nonstandard table. It takes its values from the mysql.user table.