对PG数据库user和schema的理解

[highgo@yueqi ~]$  psql -p 5866 -U u_lei  -d db_lei
psql (4.1.1)
PSQL: Release 4.1.1
Connected to:
HighGo Database V4.1 Enterprise Edition Release 4.1.1 - 64-bit Production
Type "help" for help.
db_lei=> create schema s_lei;
错误:  42501: 对数据库 db_lei 权限不够
db_lei=> exit
db_lei-> \q
[highgo@yueqi ~]$  psql 
psql (4.1.1)
PSQL: Release 4.1.1
Connected to:
HighGo Database V4.1 Enterprise Edition Release 4.1.1 - 64-bit Production
Type "help" for help.
highgo=# \c
PSQL: Release 4.1.1
Connected to:
HighGo Database V4.1 Enterprise Edition Release 4.1.1 - 64-bit Production
You are now connected to database "highgo" as user "highgo".
highgo=# \l
                               List of databases
     Name     | Owner  | Encoding |  Collate   |   Ctype    | Access privileges 
--------------+--------+----------+------------+------------+-------------------
 benchmarksql | highgo | UTF8     | zh_CN.utf8 | zh_CN.utf8 | 
 db_lei       | highgo | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =Tc/highgo       +
              |        |          |            |            | highgo=CTc/highgo+
              |        |          |            |            | u_lei=c/highgo
 db_zhang     | highgo | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =Tc/highgo       +
              |        |          |            |            | highgo=CTc/highgo+
              |        |          |            |            | u_zhang=c/highgo
 highgo       | highgo | UTF8     | zh_CN.utf8 | zh_CN.utf8 | 
 template0    | highgo | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =c/highgo        +
              |        |          |            |            | highgo=CTc/highgo
 template1    | highgo | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =c/highgo        +
              |        |          |            |            | highgo=CTc/highgo
(6 rows)
highgo=# grant create on database db_lei to u_lei;
GRANT
highgo=# 
结论:1.schema是每个database中都有的。
           2.user是pg cluster级别的。
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值