Re: Permission denied for sequence

[Michael Glaesemann <grzm(at)seespotcode(dot)net>]

On May 31, 2007, at 14:53 , Hackenberg, Rick wrote:

> I am currently having a problem with an application that has been  
> working fine for the past few months. Whenever I try to add a new  
> entry into a table I receive the following message:
>
> ERROR: permission denied for sequnce contractid
Please make sure you're providing the exact error message (i.e., copy  
& paste).

Assuming you have a DEFAULT nextvai(contractid) on some column in the  
table, you need UPDATE permissions on the sequence to use nextval.  
See the GRANT documention page:

http://www.postgresql.org/docs/8.2/interactive/sql-grant.html

Michael Glaesemann
grzm seespotcode net