doris 用户

🧙 Questions

• 创建用户
• 修改密码

  ☄️ Ideas

创建用户

-- 创建用户
CREATE USER IF NOT EXISTS 'ispong'@'%' Identified BY 'ispong123';

-- 创建DB
CREATE DATABASE ispong_db;

-- 授权所有权限给用户在这个DB上
GRANT SELECT_PRIV,LOAD_PRIV,ALTER_PRIV,CREATE_PRIV,DROP_PRIV ON ispong_db.* TO 'ispong'@'%';
GRANT ALL ON ispong_db.* TO 'ispong'@'%';

修改密码

SET PASSWORD FOR 'root' = PASSWORD('ispong123');

🔗 Links

• doris docs
• doris user