ERROR: role "data" cannot be dropped because some objects depend on it





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