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

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

Asked Aug 23, 2024 Modified Jan 1, 0001
Viewed 61
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
阿渊@SelectDB8285
answered Aug 23, 2024
Related Questions
flink-doris-connector的25.1.0版本使用CdcMysqlSyncDatabaseCase当任务启动后MySQL后新增的表无法同步,还需要其它什么设置
1 answers
使用聚合模型聚合小时数据,出现前后结果不一致该如何排查
1 answers
Doris实现动态行转列
1 answers
doris2.0.3 mow表数据莫名奇妙的减少了
2 answers
对于JSON_ARRAY JSON数组嵌套数据的处理,大家有什么好的处理办法吗?
doris be节点下线扩容,以一个新节点重新添加到集群后,UsedPct统计出错,导致集群间数据无法均衡
2 answers

Terms of service Privacy policy

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