On 01/27/2014 01:45 PM, Susan Cassidy wrote:
I tried: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser; and I get: ERROR: syntax error at or near "ALL" LINE 1: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO te... also the same thing for tables, with the same results. Am I misinterpreting the syntax for this?
Depends on what version of Postgres you are working with. The syntax of commands changes with time.
So what Postgres version are you using?
Susan
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general