pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Henshall, Stuart - WCP <SHenshall@westcountrypublications.co.uk>
To: 'posting-list@MailAndNews.com' <posting-list@MailAndNews.com>
To: pgsql-sql@postgresql.org
Subject: Re: GRANT ALL ON TO GROUP failure
Date: Tue, 4 Sep 2001 10:53:19 +0100
Message-ID: <E2870D8CE1CCD311BAF50008C71EDE8E01F74696@MAIL_EXCHANGE> (raw)

	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
> 



view thread (7+ messages)

Message-ID: <E2870D8CE1CCD311BAF50008C71EDE8E01F74696@MAIL_EXCHANGE>
Permalink:  ../E2870D8CE1CCD311BAF50008C71EDE8E01F74696@MAIL_EXCHANGE/
Also on:    postgresql.org/message-id/E2870D8CE1CCD311BAF50008C71EDE8E01F74696@MAIL_EXCHANGE

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: SHenshall@westcountrypublications.co.uk, posting-list@MailAndNews.com
  Subject: Re: GRANT ALL ON TO GROUP failure
  In-Reply-To: <E2870D8CE1CCD311BAF50008C71EDE8E01F74696@MAIL_EXCHANGE>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox