postgresql 创建用户和授权详解数据库

CREATE USER chentest WITH PASSWORD ' 123456'  VALID UNTIL '2020-04-28'; 
 
ALTER USER  chenrenxun CONNECTION LIMIT 20 login; 
 
GRANT CONNECT ON DATABASE tenant_1008439 TO chenrenxun; 
 
GRANT USAGE ON SCHEMA public TO chenrenxun; 
 
GRANT SELECT,update,INSERT,delete ON ALL TABLES IN SCHEMA public TO chenrenxun; 
 
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO chenrenxun;