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 NameRemarks
GRANTEE 'user_name'@'host_name' value, MySQL extension
TABLE_CATALOG def, MySQL extension
PRIVILEGE_TYPE MySQL extension
IS_GRANTABLE MySQL extension

Notes:

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

版权声明：本文为rjcs888原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。