starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

Failed to obtain JDBC Connection

Open happyi opened this issue 1 year ago • 1 comments

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

happyi avatar Aug 24 '23 04:08 happyi

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!

github-actions[bot] avatar Feb 26 '24 11:02 github-actions[bot]