PG删除用户报错:
[postgres:7471@postgres] [08-24.19:50:18]=# drop user data;
ERROR: role "data" cannot be dropped because some objects depend on it
DETAIL: privileges for schema public
解决方法是回收对public的权限
[postgres:7471@postgres] [08-24.19:52:15]=# revoke create on schema public from data;
REVOKE
Time: 3.884 ms
[postgres:7471@postgres] [08-24.19:52:22]=# drop user data;
DROP ROLE
Time: 1.720 ms