Postgres用户创建数据库的权限

用户创建数据库的权限

（1）检查确认超级用户highgo拥有创建数据库的权限，普通用户a没有创建数据库的权限

highgo=#\du

                             List of roles

 Role name |                   Attributes                   | Member of

-----------+------------------------------------------------+-----------

 a        |                                               | {}

 highgo   | Superuser, Create role, Create DB, Replication | {}

 

highgo=#select current_user;

 current_user

--------------

 highgo

(1row)

 

highgo=#create database highgo_t;

CREATEDATABASE

highgo=#\c highgo a

Youare now connected to database "highgo" as user "a".

highgo=>create database a_t;

错误:  创建数据库权限不够