postgresql - Postgres 9.1 GRANT 不起作用

Question

我尝试授予这样的特权:

zielony=# GRANT ALL PRIVILEGES ON DATABASE baza_tag to strona_user;
GRANT

但什么也没发生:

usename   | usesysid | usecreatedb | usesuper | usecatupd | userepl |  passwd  | valuntil | useconfig 
-------------+----------+-------------+----------+-----------+---------+----------+----------+-----------
postgres    |       10 | t           | t        | t         | t       | ******** |          | 
zielony     |    16384 | t           | t        | t         | t       | ******** |          | 
strona_user |    16440 | f           | f        | f         | f       | ******** |          | 

此外，我无法通过 php 进行任何访问。我错过了什么？

Answer 1

PostgreSQL 权限系统不是那样工作的。您将必须对对象本身设置权限。像这样:

GRANT ALL ON ALL TABLES IN SCHEMA public TO strona_user;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO strona_user;
GRANT ALL ON ALL FUNCTIONS IN SCHEMA public TO strona_user;

您可能还需要为您的架构授予权限。

GRANT ALL ON SCHEMA public TO strona_user;