为了更快的定位您的问题,请提供以下信息,谢谢
【详述】StarRocks从3.0.2升级到3.1.1版本,账号登录异常
报错信息:Access denied; you need (at least one of) the ANY privilege(s) on DATABASE tmp for this operation
新建测试账号也一样报错:
create test user as follow:
CREATE USER ‘test_user’@’%’ IDENTIFIED BY ‘123456’;
grant all privileges on all MATERIALIZED VIEWS in database tmp to ‘test_user’@’%’;
grant all privileges on all VIEWS in database tmp to ‘test_user’@’%’;
grant all privileges on all tables in database tmp to ‘test_user’@’%’;
check the user privileges:
MySQL [(none)]> show grants for test_user;
±----------------±----------------±----------------------------------------------------------------------------------------------------------------+
| UserIdentity | Catalog | Grants |
±----------------±----------------±----------------------------------------------------------------------------------------------------------------+
| ‘test_user’@’%’ | default_catalog | GRANT DELETE, DROP, INSERT, SELECT, ALTER, EXPORT, UPDATE ON ALL TABLES IN DATABASE tmp TO USER ‘test_user’@’%’ |
| ‘test_user’@’%’ | default_catalog | GRANT SELECT, ALTER, DROP ON ALL VIEWS IN DATABASE tmp TO USER ‘test_user’@’%’ |
| ‘test_user’@’%’ | default_catalog | GRANT ALTER, REFRESH, DROP, SELECT ON ALL MATERIALIZED VIEWS IN DATABASE tmp TO USER ‘test_user’@’%’ |
【背景】版本升级
【业务影响】账号相关操作不可用
【StarRocks版本】例如:3.1.1
【集群规模】例如:3fe(1 follower+2observer)+8be
辛苦大佬帮忙看下,谢谢,
GitHub上也有相关issue: 版本升级到3.1.1后报错 · Issue #30118 · StarRocks/starrocks (github.com)
