Re: GRANT giving error on sequence in 7.4.19 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: GRANT giving error on sequence in 7.4.19
Date
Msg-id 200803140650.00759.aklaver@comcast.net
Whole thread Raw
In response to GRANT giving error on sequence in 7.4.19  ("Kakoli Sen" <kakolis@cdacb.ernet.in>)
List pgsql-general
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

pgsql-general by date:

Previous
From: luca.ciciriello@email.it
Date:
Subject: LOCK TABLE HELP
Next
From: Alvaro Herrera
Date:
Subject: Re: Reindex does not finish 8.2.6