[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级别的。