permission denied for schema - Mailing list pgsql-general

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