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

Question

报错：
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版本。

阿渊@SelectDB (没回帖直接加我主页微信) · Accepted Answer

参考：

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

GRANT DEMO

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

1 Answers