11.2.1.3 撤销用户的权限
11.2.1.3.1 删除没有授权的账户
11.2.1.3.1.1 撤销权限
登录到管理员账户删除刚创建的user1
auth_test=# drop role if exists...into schema1.test1(id,name) values(1,'1');
INSERT 0 1
auth_test=> select * from schema1.test1;
id |...,update,delete,insert on schema1.test1 from user1;
REVOKE
auth_test=# revoke usage on schema schema1...-h 192.168.***.55 -U user1 -d auth_test
auth_test=> grant select,update,delete,insert on schema1.test1...,delete,insert on schema1.test1 from user2;
REVOKE
11.2.4.6 查看撤销后的效果
登录到user2用户下查询user1下的数据
$ psql -h