i get this when i try to insert a record into a table. all permissions / privileges seems ok, but probably i missed something. i am running a 8.1.3 on linux.

registratie=> INSERT INTO clienten (anoniem,geslacht,leeftijd,origine,team_id,hulpverlener_id) VALUES ('true','45','58','864','30','221');
ERROR:  permission denied for schema deterp
CONTEXT: SQL statement "SELECT 1 FROM ONLY "deterp"."teams" x WHERE "id" = $1 FOR SHARE OF x"

registratie=> \dn
          List of schemas
        Name        |     Owner
--------------------+---------------
 dekempen           | jpe
 deterp             | jpe
 information_schema | postgres
 mozaiek            | mozaiek_admin
 pg_catalog         | postgres
 pg_toast           | postgres
 public             | postgres
 testsaw            | testsaw_admin
(8 rows)

registratie=> \dn+

            List of schemas
Name | Owner | Access privileges | Description
--------------------+---------------+--------------------------------------------------------------------------------------------------------------+----------------------------------
dekempen | jpe | {jpe=UC/jpe,cawdekempen=UC/jpe}
     |
deterp | jpe | {jpe=UC/jpe,deterp_group=UC/jpe,terp_user=UC/jpe} | information_schema | postgres | {postgres=UC/postgres,=U/postgres} | mozaiek | mozaiek_admin | {mozaiek_admin=UC/mozaiek_admin,jpe=UC/mozaiek_admin,mozaiek_user=UC/mozaiek_admin,mozaiek=UC/mozaiek_admin} | pg_catalog | postgres | {postgres=UC/postgres,=U/postgres} | System catalog schema pg_toast | postgres |
     | Reserved schema for TOAST tables
public | postgres | {postgres=UC/postgres,=UC/postgres,deterp_group=U/postgres,cawdekempen=U/postgres} | Standard public schema testsaw | testsaw_admin | {testsaw_admin=UC/testsaw_admin,jpe=UC/testsaw_admin,testsaw_user=UC/testsaw_admin,testsaw=UC/testsaw_admin} |
(8 rows)

registratie=> \d clienten
                              Table "deterp.clienten"
     Column      |   Type   |                       Modifiers
-----------------+----------+-------------------------------------------------------
id | integer | not null default nextval('clienten_id_seq'::regclass)
 anoniem         | boolean  | not null default false
 naam            | text     |
 voornamen       | text     |
 geslacht        | smallint |
 leeftijd        | smallint |
 geboortedatum   | date     |
 origine         | smallint |
 team_id         | integer  |
 hulpverlener_id | integer  |
Indexes:
    "pk_deterp_clienten" PRIMARY KEY, btree (id)
Foreign-key constraints:
"fk_clienten_geslacht" FOREIGN KEY (geslacht) REFERENCES lijst_items(score) ON UPDATE RESTRICT ON DELETE RESTRICT "fk_clienten_hv_id" FOREIGN KEY (hulpverlener_id) REFERENCES gebruikers(id) ON UPDATE RESTRICT ON DELETE RESTRICT "fk_clienten_leeftijd" FOREIGN KEY (leeftijd) REFERENCES lijst_items(score) ON UPDATE RESTRICT ON DELETE RESTRICT "fk_deterp_clienten_team_id" FOREIGN KEY (team_id) REFERENCES teams(id) ON UPDATE RESTRICT ON DELETE RESTRICT

registratie=> \z clienten_id_seq
                   Access privileges for database "registratie"
 Schema |      Name       |   Type   |             Access privileges
--------+-----------------+----------+--------------------------------------------
deterp | clienten_id_seq | sequence | {jpe=arwdRxt/jpe,deterp_group=arwdRxt/jpe}
(1 row)


registratie=> \dg
                                    List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
----------------+-----------+-------------+-----------+-------------+----------------
 cawdekempen    | no        | no          | no        | no limit    |
 db_admin       | yes       | yes         | yes       | no limit    |
dekempen_admin | no | no | no | no limit | {cawdekempen} dekempen_user | no | no | no | no limit | {cawdekempen}
 deterp         | no        | no          | no        | no limit    |
 deterp_group   | no        | no          | no        | no limit    |
 deterp_resp    | no        | no          | no        | no limit    |
jpe | yes | yes | yes | no limit | {mozaiek} liesbet | no | no | no | no limit | {cawdekempen}
 mozaiek        | no        | no          | no        | no limit    |
mozaiek_admin | no | yes | yes | no limit | {mozaiek} mozaiek_user | no | no | no | no limit | {mozaiek}
 postgres       | yes       | yes         | yes       | no limit    |
terp_admin | no | no | no | no limit | {deterp_group} terp_user | no | no | no | no limit | {deterp_group}
 testsaw        | no        | no          | no        | no limit    |
testsaw_admin | no | yes | yes | no limit | {testsaw} testsaw_user | no | no | no | no limit | {testsaw}
 tom            | no        | no          | yes       | no limit    |
 tomdec         | no        | yes         | yes       | no limit    |
(20 rows)

registratie=> \du
                                    List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
----------------+-----------+-------------+-----------+-------------+----------------
 cawdekempen    | no        | no          | no        | no limit    |
 db_admin       | yes       | yes         | yes       | no limit    |
dekempen_admin | no | no | no | no limit | {cawdekempen} dekempen_user | no | no | no | no limit | {cawdekempen}
 deterp         | no        | no          | no        | no limit    |
 deterp_group   | no        | no          | no        | no limit    |
 deterp_resp    | no        | no          | no        | no limit    |
jpe | yes | yes | yes | no limit | {mozaiek} liesbet | no | no | no | no limit | {cawdekempen}
 mozaiek        | no        | no          | no        | no limit    |
mozaiek_admin | no | yes | yes | no limit | {mozaiek} mozaiek_user | no | no | no | no limit | {mozaiek}
 postgres       | yes       | yes         | yes       | no limit    |
terp_admin | no | no | no | no limit | {deterp_group} terp_user | no | no | no | no limit | {deterp_group}
 testsaw        | no        | no          | no        | no limit    |
testsaw_admin | no | yes | yes | no limit | {testsaw} testsaw_user | no | no | no | no limit | {testsaw}
 tom            | no        | no          | yes       | no limit    |
 tomdec         | no        | yes         | yes       | no limit    |
(20 rows)

r


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to