如何删除用户的“CreateDB”权限？(How to drop the “CreateDB” permission for a user?)

如何删除用户的“CreateDB”权限？(How to drop the “CreateDB” permission for a user?)

我做到了

ALTER USER someuser WITH CREATEDB;

我怎么可以撤销它？ 我试过了

revoke CREATEDB from crawler;

有错误角色“createdb”不存在

我在postgresql 9.6.1上

I did

ALTER USER someuser WITH CREATEDB;

How could I revoke it please? I tried

revoke CREATEDB from crawler;

Got error role "createdb" does not exist

I am on postgresql 9.6.1

最满意答案

只需再次改变用户并设置相反的选项：

ALTER USER someuser WITH NOCREATEDB;

这应该删除用户创建数据库的权限。

Just alter the user again and set the opposite option:

ALTER USER someuser WITH NOCREATEDB;

That should remove the permission to create databases from the user.