On Wednesday 30 Oct 2002 5:54 pm, s-psql@rhythm.cx wrote:
> On Wed, Oct 30, 2002 at 10:02:38AM +0000, Richard Huxton wrote:
> > Do you have any serial types or sequences on the table? If so, you'll
> > need to check permissions on those too.
>
> Yep, all relevant sequences have permissions too:
>
> csclub=> \z
> Access privileges for database "csclub"
> Table | Access privileges
> -------------------------+------------------------------------
> ...
> cscuser | {=,webauth=arwdRxt}
> cscuser_userid_seq | {=,csclub=arwdRxt,webauth=arwdRxt}
> websess | {=,webauth=arwdRxt}
> csclub=> INSERT INTO websess(hash,userid,created)
> VALUES('abde',1,'2002-09-20');
> ERROR: cscuser: Permission denied.
>
>
> Anyone have any other ideas?
Well - assuming it is connecting as 'webauth' the only thing I can suggest is
to dump the schema, edit it down to a minimum, reload it to a test db and see
if that pins down the problem.
- Richard Huxton