On Wednesday 30 Oct 2002 6:53 am, s-psql(at)rhythm(dot)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