删除user:
revoke all on database databasename from username;
(databasename:数据库名,username:用户名,收回此需删除的用户对数据库的所有权限)
(注:当前数据库有默认schema:public,试试这个)
DROP user username;(现在删除就不会有任何权限受限而删除失败)
GRANT ALL PRIVILEGES ON DATABASE databasename TO username;
somedatabase=# REVOKE SELECT ON sometable FROM user;
REVOKE
somedatabase=#