Received: from smtp2.koti.soon.fi (kotiposti.reimari.net [212.63.10.60]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7TLKHf16313 for ; Wed, 29 Aug 2001 17:20:17 -0400 (EDT) (envelope-from jari.aalto@poboxes.com) Received: from poboxes.com (ip10-019.dial.tpo.fi [212.246.177.19]) by smtp2.koti.soon.fi (8.9.0/8.9.0) with ESMTP id AAA02352 for ; Thu, 30 Aug 2001 00:20:03 +0300 (EET DST) From: posting-list@MailAndNews.com (Jari Aalto) To: pgsql-sql@postgresql.org Subject: GRANT ALL ON TO GROUP failure Keywords: granting,user,sql,group,reader,pg-def-group-grant,grant,error X-Sender-Info: Emacs resources http://tiny-tools.sourceforge.net/ http://home.eu.org/~jari/homepage.html. ICQ 'jari-aalto' 82313129 PGP 2.6.x keyid 47141D35 http://www.pgpi.net/ Date: Thu, 30 Aug 2001 00:26:40 +0300 Message-ID: User-Agent: Gnus/5.090004 (Oort Gnus v0.04) Emacs/20.7 (i386-*-nt5.0.2195) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Lines: 90 X-Archive-Number: 200108/355 X-Sequence-Number: 4605 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