USER_ATTRIBUTES
USER_PRIVILEGES 表提供关于用户注释和用户属性的信息。这些信息来自 mysql.user 系统表。
USE information_schema;
DESC user_attributes;
+-----------+--------------+------+------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+------+---------+-------+
| USER | varchar(32) | NO | | NULL | |
| HOST | varchar(255) | NO | | NULL | |
| ATTRIBUTE | longtext | YES | | NULL | |
+-----------+--------------+------+------+---------+-------+
3 rows in set (0.00 sec)
USER_ATTRIBUTES 表中的字段说明如下：
USER：用户名称。HOST：用户可以连接到 TiDB 的主机。如果该字段的值为％，表示用户可以从任何主机连接到 TiDB。ATTRIBUTE：用户的注释和属性，由CREATE USER或ALTER USER语句设置。
以下是一个示例：
CREATE USER testuser1 COMMENT 'This user is created only for test';
CREATE USER testuser2 ATTRIBUTE '{"email": "user@pingcap.com"}';
SELECT * FROM information_schema.user_attributes;
+-----------+------+---------------------------------------------------+
| USER | HOST | ATTRIBUTE |
+-----------+------+---------------------------------------------------+
| root | % | NULL |
| testuser1 | % | {"comment": "This user is created only for test"} |
| testuser2 | % | {"email": "user@pingcap.com"} |
+-----------+------+---------------------------------------------------+
3 rows in set (0.00 sec)