You need to user is a reserved word so you need to quote it (ie:
"user" rather than user) whenever you reference it.Does group reader exist?
If it does then it might be a case issue as presumably you must have quoted
user user to create it which also preserves case, so if you did the same for
group reader and included any caps reader will need to be quoted and in the
same case.
- Stuart
> -----Original Message-----
> From: posting-list@MailAndNews.com [SMTP:posting-list@MailAndNews.com]
> Sent: Monday, September 03, 2001 5:35 PM
> To: pgsql-sql@postgresql.org
> Subject: GRANT ALL ON TO GROUP failure
>
>
> Can anyone suggest, what is wrong with the following
> sql file? SOmehow the semicolon causes error?
>
> Jari
>
> 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"
> Granting SELECT to READER
> psql:pg-def-group-grant.sql:69: ERROR: non-existent group "reader"
>
> 01:-- Postgres create table rights
> 02:-- $Id: pg-def-group-grant.sql,v 1.1 2001/08/23 19:26:16 jaalto Exp $
> 03:--
> 04:--
> 05:-- GRANT allows the creator of an object to give specific permissions
> to
> 06:-- all users (PUBLIC) or to a certain user or group. Users other than
> the
> 07:-- creator don't have any access permission unless the creator GRANTs
> 08:-- permissions, after the object is created.
> 09:
> 10:\echo Granting ALL to ROOT
> 11:
> 12:GRANT ALL ON
> 13: bonus
> 14: , custid
> 15: , customer
> 16: , dept
> 17: , dual
> 18: , dummy
> 19: , emp
> 20: , item
> 21: , ordid
> 22: , ordx
> 23: , price
> 24: , prodid
> 25: , product
> 26: , sales
> 27: , salgrade
> 28: TO GROUP root;
> 29:
> 30:\echo Granting ALL to USER
> 31:
> 32:GRANT ALL ON
> 33: bonus
> 34: , custid
> 35: , customer
> 36: , dept
> 37: , dual
> 38: , dummy
> 39: , emp
> 40: , item
> 41: , ordid
> 42: , ordx
> 43: , price
> 44: , prodid
> 45: , product
> 46: , sales
> 47: , salgrade
> 48: TO GROUP user;
> 49:
> 50:
> 51:\echo Granting SELECT to READER
> 52:
> 53:GRANT SELECT ON
> 54: bonus
> 55: , custid
> 56: , customer
> 57: , dept
> 58: , dual
> 59: , dummy
> 60: , emp
> 61: , item
> 62: , ordid
> 63: , ordx
> 64: , price
> 65: , prodid
> 66: , product
> 67: , sales
> 68: , salgrade
> 69: TO GROUP reader;
> 70:
> 71:-- End of file
>
> ----------
>
>
> --
> http://tiny-tools.sourceforge.net/
> Swatch @time http://www.ryanthiessen.com/swatch/resources.htm
> Convert @time http://www.mir.com.my/iTime/itime.htm
>
