| 用户 | CREATE USER app IDENTIFIED WITH sha256_password BY '…' |
|---|---|
| 授权 | GRANT SELECT ON analytics.* TO app；GRANT SELECT(col1, col2) 列级授权 |
| 角色与配额 | CREATE ROLE/GROUP 管理批量账号；CREATE QUOTA 限制单用户资源用量 |
| 查看 | SHOW USERS / SHOW GRANTS / system.users、system.grants |
示例
示例
CREATE USER app_user IDENTIFIED WITH sha256_password BY 'S3cret';
GRANT SELECT ON analytics.* TO app_user;
SHOW GRANTS FOR app_user;
SELECT name, storage, auth_type FROM system.users;只读账号是数据平台常见需求：授权范围尽量收到库表与列级，配合 QUOTA 限制查询资源。