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 [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
