Re: GRANT ALL ON TO GROUP failure - Mailing list 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@gmx.net   http://funkturm.homeip.net/~peter