Re: problem with grant all privileges

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: problem with grant all privileges
Date: 2014-01-27 21:58:51
Message-ID: 52E6D69B.3090105@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2014-01-27 23:39:16 Re: pg_dump: dumpBlobs(): could not open large object: ERROR: large object 27729547 does not exist
Previous Message Susan Cassidy 2014-01-27 21:45:12 problem with grant all privileges