Re: permission prob: granted, but still denied

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