HGDB修改数据库用户访问权限举例

highgo=# \l
                               List of databases
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges 
-----------+--------+----------+-------------+-------------+-------------------
 highgo    | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/highgo        +
           |        |          |             |             | highgo=CTc/highgo
 template1 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
           |        |          |             |             | =c/highgo
 test      | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/highgo       +
           |        |          |             |             | highgo=CTc/highgo
(4 rows)


highgo=# REVOKE ALL ON DATABASE test FROM highgo;
REVOKE
highgo=# \l
                               List of databases
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges 
-----------+--------+----------+-------------+-------------+-------------------
 highgo    | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/highgo        +
           |        |          |             |             | highgo=CTc/highgo
 template1 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
           |        |          |             |             | =c/highgo
 test      | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/highgo
(4 rows)


highgo=# REVOKE ALL ON DATABASE test FROM PUBLIC;
REVOKE
highgo=# \l
                               List of databases
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges 
-----------+--------+----------+-------------+-------------+-------------------
 highgo    | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/highgo        +
           |        |          |             |             | highgo=CTc/highgo
 template1 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
           |        |          |             |             | =c/highgo
 test      | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
(4 rows)


highgo=# 




[highgo@hg lib]$ psql -d test -U aaa
psql (4.0.0)
Type "help" for help.


test=# \l
                               List of databases
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges 
-----------+--------+----------+-------------+-------------+-------------------
 highgo    | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/highgo        +
           |        |          |             |             | highgo=CTc/highgo
 template1 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
           |        |          |             |             | =c/highgo
 test      | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
(4 rows)


test=# GRANT ALL ON DATABASE test TO aaa;
GRANT
test=# \l
                               List of databases
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges 
-----------+--------+----------+-------------+-------------+-------------------
 highgo    | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/highgo        +
           |        |          |             |             | highgo=CTc/highgo
 template1 | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
           |        |          |             |             | =c/highgo
 test      | highgo | UTF8     | en_US.UTF-8 | en_US.UTF-8 | aaa=CTc/highgo
(4 rows)


test=#