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

Viewed 42

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

1 Answers

参考:

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

GRANT DEMO