Thread: 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