Article ID: 116323, created on Jun 21, 2013, last review on May 9, 2014

  • Applies to:
  • Plesk for Linux/Unix

Symptoms

Only user, who created table in PostgreSQL, can view/manage this table. Other users receive permision denied errors.

Cause

PostgreSQL uses fine-grained access control which are not managed by Plesk. The problem is under investigation by Product Development team and will be fixed in future releases.

Workaround

Avoid using multiple users for a single PostgreSQL database.

For databases that are already affected by the problem - grant permissions on all objects in database to all users of this database, e.g.:

admin_db1=# \z
Access privileges for database "admin_db1"
 Schema | Name          | Type     | Access privileges
--------+---------------+----------+-------------------
 public | table1        | table    |
 public | table1_id_seq | sequence |
(2 rows)
admin_db1=# GRANT ALL ON table1 TO db1user2;
GRANT
admin_db1=# GRANT ALL ON table1_id_seq TO db1user2;
GRANT
admin_db1=# \z
Access privileges for database "admin_db1"
 Schema | Name          | Type     | Access privileges
--------+---------------+----------+-------------------
 public | table1        | table    | {db1user1=arwdRxt/db1user1,db1user2=arwdRxt/db1user1}
 public | table1_id_seq | sequence | {db1user1=arwdRxt/db1user1,db1user2=arwdRxt/db1user1}
(2 rows)

29d1e90fd304f01e6420fbe60f66f838 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c

Email subscription for changes to this article
Save as PDF