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

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

Asked Aug 23, 2024 Modified Jan 1, 0001
Viewed 52
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
阿渊@SelectDB6795
answered Aug 23, 2024
Related Questions
bdb过大,3FE因为其中一台机器故障导致fe启动不了,选定了一个fe作为master重新租了集群
1 answers
官方镜像gdb使用报错
1 answers
left join 报错
1 answers
doris2.0.15 unique表部分更新出现副本数据不一致
1 answers
doris 2.0.4 某tablet持续base compaction失败重试
1 answers
执行insert into select语句,偶发be与fe连接错误,[THRIFT_RPC_ERROR]Couldn't open transport for 10.1.0.23:9020 (open() timed out)
1 answers

Terms of service Privacy policy

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