vi /etc/clickhouse-server/user.xml
<access_management>1</access_management>
clickhouse-client -m -h 127.0.0.1 -u default --password
create user zhangsan identified with sha256_password by '5552223333' host any;
select * from system.users FORMAT Vertical;
grant select on `ad_app`.* to zhangsan@'%' ;
exit;
------------------------------------------------------------------------------------
创建角色：create role read_role;
给角色授权：grant all on readonly.* to read_role;
给用户授权：grant read_role to zhangquanyuan;