Apache Doris 中文技术论坛
Questions Tags Users Badges

Doris2.0版本如何给只读账号赋予全部表的读权限。

Asked Aug 23, 2024 Modified Jan 1, 0001
Viewed 95
2.0

报错:
GRANT SELECT ON . TO 'readonly_user'@'%'

1105 - errCode = 2, detailMessage = Syntax error in line 1:
GRANT SELECT ON . TO 'readonly_user'@'%'
^
Encountered: SELECT
Expected: SELECT is keyword, maybe SELECT

查询时间: 0.005s

MySQL客户端是5.7版本。

edited Jan 1, 0001
yckonnnnnn11
asked Aug 23, 2024
1 Answers

参考:

GRANT SELECT_PRIV,ALTER_PRIV,LOAD_PRIV ON ctl1.db1.tbl1 TO 'jack'@'192.8.%';

GRANT DEMO

edited Jan 1, 1970
阿渊@SelectDB (没回帖直接加我主页微信)9880
answered Aug 23, 2024
Related Questions
Alter routine load后参数变动
1 answers
Doris Routine Load重置offset
1 answers
我的doris版本为2.0.6 在备份操作时,会导致所以fe节点宕机,这种情况该怎么排查,为什么备份会导致这个问题?
1 answers
Doris 2.0.15,3FE、6BE(3BE mix角色 3BE computation角色)3个mix角色的BE节点CPU使用率100%
1 answers
Doris Routine Load自动恢复机制
1 answers
doris fe节点变更成高可用配置
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.