创建schema(不会创建用户)
Create schema edmi;
创建schema同时设置schema owner
CREATE SCHEMA 'edmi' AUTHORIZATION 'edmi_modify';
创建用户(不会创建schema)
CREATE USER edmi_modify WITH PASSWORD 'edmi';
修改密码
ALTER USER edmi WITH PASSWORD 'modifyedmi321';
授予schema的使用权限
grant USAGE on SCHEMA edmi to edmi_modify;
撤销schema权限
revoke usage on schema edmi from edmi_modify;
授予所有表的crud权限，不含以后新建的表
grant select,delete,insert,update on all tables in schema edmi to edmi_modify;
撤销表的权限
revoke select,delete,insert,update on all tables in schema edmi from edmi_modify;
后续schema owner建的表的权限自动赋予该用户
alter default privileges for user edmi in schema edmi grant select,delete,insert,update on tables to edmi_modify;