Re: permission prob: granted, but still denied - Mailing list pgsql-general

On Wednesday 30 Oct 2002 6:53 am, s-psql@rhythm.cx wrote:
> 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.

Do you have any serial types or sequences on the table? If so, you'll need to
check permissions on those too.

--
  Richard Huxton
  Archonet Ltd