3.0.3 存算分离 errCode = 2, detailMessage = USAGE denied to user 'etl_doris_admin'@'110.711.111.318' for storage vault 's3_vault'

Viewed 11
decoupled 3.0

创建表的时候提示下面的错误

Exception in thread "main" java.sql.SQLException: errCode = 2, detailMessage = USAGE denied to user 'etl_doris_admin'@'110.711.111.318' for storage vault 's3_vault'

etl_doris_admin 拥有rwd_all_db 角色相关的权限，具体信息如下：

CREATE ROLE rwd_all_db  COMMENT "读写、ddl所有数据库";
GRANT SELECT_PRIV,SHOW_VIEW_PRIV,ALTER_PRIV,CREATE_PRIV,DROP_PRIV  ON *.*.* TO ROLE 'rwd_all_db';
GRANT USAGE_PRIV ON RESOURCE * TO ROLE 'rwd_all_db';
GRANT USAGE_PRIV ON COMPUTE GROUP * TO ROLE 'rwd_all_db';

GRANT 'rwd_all_db' TO 'etl_doris_admin'@'%';
15
1 Answers

GRANT USAGE_PRIV ON STORAGE VAULT s3_vault TO ROLE 'rwd_all_db';

15