germ germ <super_code_monkey(at)yahoo(dot)com> writes:
> This is the error: 2005-07-28 08:51:08 ERROR:
> permission denied for sequence requests_req_num_seq
>
> I've tried these grants, but no luck:
> GRANT ALL ON FUNCTION nextval(integer) TO wwwrun,
> postgres;
> GRANT ALL ON FUNCTION nextval('requests_req_num_seq')
> TO wwwrun, postgres;
> GRANT ALL ON FUNCTION nextval() TO wwwrun, postgres;
You need to grant permission on the sequence itself.
GRANT ALL ON requests_req_num_seq TO wwwrun;
I think that's tghe right syntax--see the docs...
-Doug