Re: GRANT ALL ON TO GROUP failure

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jari Aalto <posting-list(at)mailandnews(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: GRANT ALL ON TO GROUP failure
Date: 2001-08-29 21:57:11
Message-ID: Pine.LNX.4.30.0108292356300.677-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jari Aalto writes:

> class=# \i pg-def-group-grant.sql
> Granting ALL to ROOT
> CHANGE
> Granting ALL to USER
> psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user"

You need to double quote "user". It's a reserved word.

> Granting SELECT to READER
> psql:pg-def-group-grant.sql:69: ERROR: non-existent group "reader"

Did you create a group named "reader"?

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oliver Elphick 2001-08-29 22:20:30 Re: GRANT ALL ON TO GROUP failure
Previous Message Jayson Callaway 2001-08-29 21:42:51 RE: changes to table creation syntax in 7.1.2?