Обсуждение: GRANT giving error on sequence in 7.4.19

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

________________________________________________________________________
KAKOLI SEN                              Ph:91-80-25341909/215(Extn. 309)
C-DAC Knowledge Park                    E-mail:
#1, Old Madras Road                     kakolis@cdacb.ernet.in
Bangalore - 560 038, INDIA              kakoli_basu@yahoo.co.in
________________________________________________________________________

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

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@comcast.net