SRE文档

深浅模式

https://cloud.tencent.com/developer/article/2410028

https://www.modb.pro/topic/659277

https://blog.ikeno.top/posts/clickhouse_cluster_install/

-- CREATE USER tklbidev
CREATE USER tklbidev IDENTIFIED BY 'old_password' ON CLUSTER production_cluster_3s2r;

-- ALTER USER tklbidev
ALTER USER tklbidev IDENTIFIED BY 'new_password' ON CLUSTER production_cluster_3s2r;

-- Create Database
CREATE DATABASE bigscreen ON CLUSTER production_cluster_3s2r;

-- Grant Cluster Usage Permission
GRANT REMOTE ON *.* TO tklbidev ON CLUSTER production_cluster_3s2r;

-- Grant Permissions
GRANT CREATE TABLE, DROP TABLE, TRUNCATE ON bigscreen.* TO tklbidev ON CLUSTER production_cluster_3s2r;
GRANT INSERT, DELETE, ALTER, SELECT ON bigscreen.* TO tklbidev ON CLUSTER production_cluster_3s2r;

-- REVOKE Permissions
REVOKE CREATE DATABASE, DROP TABLE ON CHAOTI.* FROM psmuserdev ON CLUSTER production_cluster_3s2r;

-- Check Perssions
SHOW GRANTS FOR tklbidev
-- CREATE USER tklbidev
CREATE USER tklbidev IDENTIFIED BY 'old_password' ON CLUSTER production_cluster_3s2r;

-- ALTER USER tklbidev
ALTER USER tklbidev IDENTIFIED BY 'new_password' ON CLUSTER production_cluster_3s2r;

-- Create Database
CREATE DATABASE bigscreen ON CLUSTER production_cluster_3s2r;

-- Grant Cluster Usage Permission
GRANT REMOTE ON *.* TO tklbidev ON CLUSTER production_cluster_3s2r;

-- Grant Permissions
GRANT CREATE TABLE, DROP TABLE, TRUNCATE ON bigscreen.* TO tklbidev ON CLUSTER production_cluster_3s2r;
GRANT INSERT, DELETE, ALTER, SELECT ON bigscreen.* TO tklbidev ON CLUSTER production_cluster_3s2r;

-- REVOKE Permissions
REVOKE CREATE DATABASE, DROP TABLE ON CHAOTI.* FROM psmuserdev ON CLUSTER production_cluster_3s2r;

-- Check Perssions
SHOW GRANTS FOR tklbidev