pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pulling my hair out..
3+ messages / 3 participants
[nested] [flat]

* pulling my hair out..
@ 2004-11-05 00:07  David Bear <David.Bear@asu.edu>
  0 siblings, 2 replies; 3+ messages in thread

From: David Bear @ 2004-11-05 00:07 UTC (permalink / raw)
  To: pgsql-admin

I'm using pg 7.3 on freebsd.. 

I've created a database use sql.

now, as the pg superuser I cant seem to grant any permissions on the
tables in the db..

npcenter-# \z
 Access privileges for database "npcenter"
 Schema |    Table     | Access privileges
--------+--------------+-------------------
 public | contactNames |
 public | pga_diagrams |
 public | pga_forms    |
 public | pga_graphs   |
 public | pga_images   |
 public | pga_layout   |
 public | pga_queries  |
 public | pga_reports  |
 public | pga_scripts  |
(9 rows)

npcenter=# grant all on table contactNames to group npcenter;
ERROR:  relation "contactnames" does not exist
npcenter=# grant all on table 'contactNames' to group npcenter;
ERROR:  syntax error at or near "'contactNames'" at character 20

I know I'm missing something simple... but would appreciate any help
on this.. clearly, the table 'contactNames' does exist.

I am using psql to do this.

-- 
David Bear
phone: 	480-965-8257
fax: 	480-965-9189
College of Public Programs/ASU
Wilson Hall 232
Tempe, AZ 85287-0803
 "Beware the IP portfolio, everyone will be suspect of trespassing"



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pulling my hair out..
@ 2004-11-05 00:45  Stephan Szabo <sszabo@megazone.bigpanda.com>
  parent: David Bear <David.Bear@asu.edu>
  1 sibling, 0 replies; 3+ messages in thread

From: Stephan Szabo @ 2004-11-05 00:45 UTC (permalink / raw)
  To: David Bear <David.Bear@asu.edu>; +Cc: pgsql-admin

On Thu, 4 Nov 2004, David Bear wrote:

> I'm using pg 7.3 on freebsd..
>
> I've created a database use sql.
>
> now, as the pg superuser I cant seem to grant any permissions on the
> tables in the db..
>
> npcenter-# \z
>  Access privileges for database "npcenter"
>  Schema |    Table     | Access privileges
> --------+--------------+-------------------
>  public | contactNames |
>  public | pga_diagrams |
>  public | pga_forms    |
>  public | pga_graphs   |
>  public | pga_images   |
>  public | pga_layout   |
>  public | pga_queries  |
>  public | pga_reports  |
>  public | pga_scripts  |
> (9 rows)
>
> npcenter=# grant all on table contactNames to group npcenter;
> ERROR:  relation "contactnames" does not exist
> npcenter=# grant all on table 'contactNames' to group npcenter;
> ERROR:  syntax error at or near "'contactNames'" at character 20

I think you want "contactNames" to refer to the table.
Doublequoted identifiers aren't casefolded.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pulling my hair out..
@ 2004-11-05 00:50  Michael Fuhr <mike@fuhr.org>
  parent: David Bear <David.Bear@asu.edu>
  1 sibling, 0 replies; 3+ messages in thread

From: Michael Fuhr @ 2004-11-05 00:50 UTC (permalink / raw)
  To: David Bear <David.Bear@asu.edu>; +Cc: pgsql-admin

On Thu, Nov 04, 2004 at 05:07:20PM -0700, David Bear wrote:
>
> npcenter=# grant all on table 'contactNames' to group npcenter;
> ERROR:  syntax error at or near "'contactNames'" at character 20

Try double quotes:

grant all on table "contactNames" to group npcenter;

http://www.postgresql.org/docs/7.3/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-11-05 00:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-05 00:07 pulling my hair out.. David Bear <David.Bear@asu.edu>
2004-11-05 00:45 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2004-11-05 00:50 ` Michael Fuhr <mike@fuhr.org>

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