starrocks
starrocks copied to clipboard
Failed to obtain JDBC Connection
Steps to reproduce the behavior (Required)
`-- 创建自定义角色。 CREATE ROLE read_only; -- 赋予角色所有 Catalog 的使用权限。 GRANT USAGE ON ALL CATALOGS TO ROLE read_only; -- 赋予角色所有表的查询权限。 GRANT SELECT ON ALL TABLES IN ALL DATABASES TO ROLE read_only; -- 赋予角色所有视图的查询权限。 GRANT SELECT ON ALL VIEWS IN ALL DATABASES TO ROLE read_only; -- 赋予角色所有物化视图的查询和加速权限。 GRANT SELECT ON ALL MATERIALIZED VIEWS IN ALL DATABASES TO ROLE read_only;
CREATE USER srread@'%' IDENTIFIED BY '123456' DEFAULT ROLE 'read_only';`
Expected behavior (Required)
Connectioned with jdbc work well
Real behavior (Required)
Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the ANY privilege(s) on DATABASE datacenter for this operation
StarRocks version (Required)
- You can get the StarRocks version by executing SQL
select current_version()
3.1.1-e022963
We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!