Doris权限设置Demo

最新推荐文章于 2025-03-17 11:54:45 发布

wangleigiser

最新推荐文章于 2025-03-17 11:54:45 发布

阅读量354

点赞数

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/wangleigiser/article/details/132598636

版权

Doris权限管控Demo如下：

CREATE USER 'test'@'%' IDENTIFIED BY 'test';
create database testdb;

GRANT SELECT_PRIV,LOAD_PRIV,ALTER_PRIV,CREATE_PRIV,DROP_PRIV on test.* TO 'test'@'%';

GRANT USAGE_PRIV ON WORKLOAD GROUP 'test_query' TO 'test'@'%';

REVOKE ALTER_PRIV,CREATE_PRIV,DROP_PRIV on test.* from 'test'@'%';

REVOKE SELECT_PRIV on test.* from 'test'@'%';