postgresql – Postgres在授予角色权限后无法创建数据库

发布时间：2020-12-13 15:50:09 所属栏目：百科来源：网络整理

导读：我确定我错过了一些简单的东西,但我创造了以下内容： postgres=# du List of roles Role name | Attributes | Member of-----------+-----------------------------------------+----------- admin | No inheritance,Create DB,Cannot login | {} postgres

我确定我错过了一些简单的东西,但我创造了以下内容：

postgres=# du
                          List of roles
 Role name |               Attributes                | Member of
-----------+-----------------------------------------+-----------
 admin     | No inheritance,Create DB,Cannot login | {}
 postgres  | Superuser,Create role,Create DB       | {}
 wade      |                                         | {admin}

(请注意,无法登录和无继承不会影响正在发生的事情.请参阅PostgreSQL documentation for role membership以了解原因.-bignose)

但是,当我尝试创建数据库时,我得到：

bin wwilliam$createdb -U wade test
Password:
createdb: database creation failed: ERROR:  permission denied to create database

我错过了什么？

解决方法

manual的摘录：

The INHERIT attribute governs inheritance of grantable privileges (that is,access privileges for database objects and role memberships). It does not apply to the special role attributes set by CREATE ROLE and ALTER ROLE. For example,being a member of a role with CREATEDB privilege does not immediately grant the ability to create databases,even if INHERIT is set; it would be necessary to become that role via SET ROLE before creating a database.

(强调我的).

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!