permission prob: granted, but still denied

From: s-psql(at)rhythm(dot)cx
To: pgsql-general(at)postgresql(dot)org
Subject: permission prob: granted, but still denied
Date: 2002-10-30 06:53:47
Message-ID: 20021030015346.A17528@infinity.rhythm.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello, I'm having some sort of permission problem on my database, running
version 7.2.3.

The user in question is 'webauth', who does not own any of the objects in
question, nor is a superuser. He has been GRANTed ALL to a table 'websess' as
well as a table websess references, 'cscuser'. However, when that user
attempts to INSERT a valid row into table websess,

ERROR: cscuser: Permission denied.

is returned. Does anyone know why that occurs? The owner of the database &
tables is able to insert rows just fine.

Here is a sample session:

% psql csclub webauth
csclub=> INSERT INTO websess(hash,userid,created)
VALUES('ef7a3c41a798d535aba526d5c0dfe251',2,'2002-10-19');
ERROR: cscuser: Permission denied.
csclub=> \z
Access privileges for database "csclub"
Table | Access privileges
-------------------------+------------------------------------
...
websess | {=,webauth=arwdRxt}
cscuser | {=,webauth=arwdRxt}
cscuser_userid_seq | {=,webauth=arwdRxt}
...

Thanks for any help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tommi Maekitalo 2002-10-30 07:13:53 Re: gborg redirect problem
Previous Message Viacheslav N Tararin 2002-10-30 06:45:34 Database Design tool