permission denied for schema

From: jef peeraer <jef(dot)peeraer(at)telenet(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: permission denied for schema
Date: 2007-06-22 20:59:13
Message-ID: 467C3821.7080306@telenet.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2007-06-22 21:10:51 Re: A problem in inheritance
Previous Message Scott Marlowe 2007-06-22 20:38:12 Re: Establishing a primary key