一、创建用户组
create group test_group;
二、创建用户
create user test_user with password '123test' in group test_group;
三、赋予只读权限
revoke create on schema dim from group test_group;
grant usage on schema dim to group test_group;
grant select on all tables in schema dim to group test_group;
alter default privileges in schema dim grant select on tables to group test_group;
多个schema,用逗号分隔
revoke create on schema fdt,gdt from group test_group;