On Friday 14 March 2008 4:19 am, Kakoli Sen wrote:
> Hello all,
> I'm giving the query
> GRANT ALL PRIVILEGES ON SEQUENCE object_seq TO tester;
> ERROR: syntax error at or near "object_seq" at character 34.
>
> \ds is listing out the sequence.
>
> Regards,
>
> Kakoli
Try:
GRANT ALL PRIVILEGES ON object_seq TO tester;
There is no SEQUENCE keyword in the GRANT command in 7.4 and a SEQUENCE is
basically a one row table.
--
Adrian Klaver
aklaver(at)comcast(dot)net